Page 1 of 1

Create Method fails with ORA-01460

Posted: Fri 10 Nov 2017 08:25
by Mike@Devart
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!

Re: Create Method fails with ORA-01460

Posted: Tue 14 Nov 2017 14:31
by Shalex
Thank you for your report. We will notify you when the issue is fixed.

Re: Create Method fails with ORA-01460

Posted: Fri 24 Nov 2017 09:28
by Shalex
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