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!
Create Method fails with ORA-01460
Re: Create Method fails with ORA-01460
Thank you for your report. We will notify you when the issue is fixed.
Re: Create Method fails with ORA-01460
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
- The usage of long identifiers (up to 140 symbols) for naming model objects is supported