Re: PRO*COBOL Problem!

If CUSTKEY is not nullable (sounds like it might be), Oracle may be having a problem with the indicator variable. Have you tried RETURNING CUSTKEY INTO :ws-custkey

In article <7vckgv$1ea$1_at_nnrp1.deja.com>,   eraskin_at_my-deja.com wrote:
> Is there anyone out there using PRO*COBOL for Oracle 8i (8.1.5). I'm
> getting an error when using a "RETURNING <field> INTO <bindvar>"
clause.
>
> The example statement is:
>
> EXEC SQL
> INSERT INTO CUSTOMER
> (CUSTNAME, CUSTPHONE)
> VALUES
> ('TEST CUSTOMER', '123-456-7890')
> RETURNING CUSTKEY INTO :ws-custkey:ws-custkey-ind
> END-EXEC.
>
> [Note that CUSTKEY is initialized from a sequence in an insert
trigger]
>
> When this code is executed, I get the following error:
>
> ORA-24343: user defined callback error
>
> When I remove the RETURNING clause, the error goes away.
>
> The CUSTKEY column is NUMBER(7,0) and ws-custkey is PIC s9(9) comp-5.
> ws-custind is pic s9(4) comp-5.
>
> Does anyone have any advice on what's wrong? If not, is there a work-
> around or another way to get the primary key back after it was
assigned
> in a trigger?
>
> TIA
>
> Eric Raskin
> eraskin_at_paslists.com
> ericraskin_at_hotmail.com
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sat Oct 30 1999 - 12:11:39 CEST