Re: Java stored function - mapping of PLS_INTEGER in PL/SQL

That mapping gives me:

ORA-00932: inconsistent datatypes: expected Invalid SQL type

NUMBER data type will work but it still might be insufficient to store the precision provided by java.math.BigDecimal.

Richard

Spencer wrote:
>
> Just a quick query - could someone please confirm if a mapping from
> PLS_INTEGER to java.lang.BigDecimal is valid in the following Java
> stored function declaration please.
> Thank you very much in advance.
> Spencer
>
> CREATE OR REPLACE FUNCTION testFunction(s1 VARCHAR2) RETURN
> PLS_INTEGER
> AS LANGUAGE JAVA NAME 'com.testFunction(java.lang.String) return
> java.math.BigDecimal';
Received on Wed Sep 25 2002 - 15:26:08 CDT