1 Reply Latest reply on Sep 12, 2014 3:38 PM by rp0428

    Ref cursor as return from a function in SQL developer

    2744947

      Hi Team,

                    I have one function which is returning a ref cursor from a function while getting an number input. But once I create a single test implementation on it with a valid input it is throwing error as below and getting failed. My version of SQL developer is 4.0.2.15.21 and it is running on Linux OS (GNU/Linux  3.10.0-123.6.3.el7.x86_64). Below is the error what I am getting.

      Unable to convert <oracle.jdbc.driver.OracleResultSetImpl@5925237> to NUMBER.

      oracle.dbtools.raptor.datatypes.oracle.sql.NUMBER.customUnscaledInternalValue(NUMBER.java:93)

      oracle.dbtools.raptor.datatypes.oracle.sql.NumericDatum.customInternalValue(NumericDatum.java:37)

      oracle.dbtools.raptor.datatypes.impl.DataTypeImpl.customInternalValueFilter(DataTypeImpl.java:411)

      oracle.dbtools.raptor.datatypes.impl.DataTypeImpl.getInternalValue(DataTypeImpl.java:399)

      oracle.dbtools.raptor.datatypes.impl.DataValueImpl.<init>(DataValueImpl.java:55)

      oracle.dbtools.raptor.datatypes.impl.DataTypeImpl.customDataValue(DataTypeImpl.java:196)

      oracle.dbtools.raptor.datatypes.impl.DataTypeImpl.getDataValue(DataTypeImpl.java:178)

      oracle.dbtools.unit_test.runner.UtRunnerImplIterator$UtRunnerImplObject.getDynamicValueByName(UtRunnerImplIterator.java:324)

      oracle.dbtools.unit_test.runner.UtRunnerImplIterator$UtRunnerImplObject.mapDynamicValueByName(UtRunnerImplIterator.java:301)

      oracle.dbtools.unit_test.runner.UtRunnerImplIterator$Ut ...

       

      Please help me here.