Create Method fails with ORA-01460

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
Mike@Devart
Posts: 3
Joined: Fri 08 Sep 2017 11:53

Create Method fails with ORA-01460

Post by Mike@Devart » Fri 10 Nov 2017 08:25

Hello all

We face the following problem with Oracle 12.2. Since Oracle 12c R2 (12.2) stored procedure names can have 128 bytes instead of 30 which was the maximum before. See also http://docs.oracle.com/database/122/NEW ... 9255D7246B

If you do a model update from database (database first) and try to "Create Method", you get the following oracle error: "Failed to obtain metadata of procedure result set. ORA-01460: unimplemented or unreasonable conversion requested"

For sure, a solution might be to truncate the name of the stored procedure or function, but IMHO the 128 bytes must be supported.

Thanks in advance!

Shalex
Site Admin
Posts: 8245
Joined: Thu 14 Aug 2008 12:44

Re: Create Method fails with ORA-01460

Post by Shalex » Tue 14 Nov 2017 14:31

Thank you for your report. We will notify you when the issue is fixed.

Shalex
Site Admin
Posts: 8245
Joined: Thu 14 Aug 2008 12:44

Re: Create Method fails with ORA-01460

Post by Shalex » Fri 24 Nov 2017 09:28

Please upgrade to v9.5.399. It includes the following improvements:
  • The bug with getting information about parameters for stored procedures with long names via OracleCommandBuilder.DeriveParameters for Oracle 12c R2 is fixed
Entity Developer
  • The usage of long identifiers (up to 140 symbols) for naming model objects is supported

Post Reply