Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Error ORA-00932 when calling Java Stored Procedure

Re: Error ORA-00932 when calling Java Stored Procedure

From: Krassimir Boyanov <kboyanov_at_printrak.com>
Date: 14 Mar 2002 08:36:49 -0800
Message-ID: <15071bed.0203140836.755eea38@posting.google.com>


Any suggestions?
Krassi

kboyanov_at_printrak.com (Krassimir Boyanov) wrote in message news:<15071bed.0203111754.51b05fa6_at_posting.google.com>...
> Hi,
>
> I want to pass VARCHAR2 into a Java Stored Procedure.
> Below is the procedure declaration, which is part of a package
> specification.
> ...
> MEMBER PROCEDURE set_ename(ename VARCHAR2)
> AS LANGUAGE JAVA
> NAME 'Paymaster.setEname(java.lang.String)'
> ...
>
> Unfortunatelly, I am getting the following error:
> ORA-00932: inconsistent datatypes
>
> However, in the same package I have the following procedure, which
> works just fine:
> MEMBER PROCEDURE raise_sal (r NUMBER)
> AS LANGUAGE JAVA
> NAME 'Paymaster.raiseSal(java.math.BigDecimal)'
>
> So what is the deal? When pass number, mapped to java.math.BigDecimal
> -> no problem. When pass NVARCHAR2, mapped to java.lang.String ERROR
> ORA-00932.
>
> Please help.
>
> Many TIA.
>
> Krassi
Received on Thu Mar 14 2002 - 10:36:49 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US