Create Method fails with ORA-01460
Posted: 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!
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!