Create Method fails with ORA-01460

Create Method fails with ORA-01460

Postby 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/NEWFT/new_features.htm#GUID-64283AD6-0939-47B0-856E-5E9255D7246B

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!
Mike@Devart
 
Posts: 3
Joined: Fri 08 Sep 2017 11:53

Re: Create Method fails with ORA-01460

Postby Shalex » Tue 14 Nov 2017 14:31

Thank you for your report. We will notify you when the issue is fixed.
Shalex
Devart Team
 
Posts: 7780
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for Oracle