Re: PL/SQL 8.1.6 : RETURNING CLAUSE problems

From: Jacques Desmazieres <nospam.jacques.desmazieres_at_is2france.com>
Date: 2000/07/20
Message-ID: <Ybxd5.484$IO2.2148379@nnrp1.proxad.net>#1/1

First there is a syntax error in this function: you have to specify the return code in the function prototype, or you should use a procedure instead

Should be

PROCEDURE domainWriteQuery

                    (
                        pnValue IN NUMBER,
                        pnNewKey OUT NUMBER )

IS
BEGIN
    INSERT INTO T_TABLE( K_KEY, V_VALUE )     VALUES ( SEQ_TABLE.NEXTVAL, pnValue )     RETURNING K_KEY INTO pnNewKey;
END domainWriteQuery;

or

FUNCTION domainWriteQuery

                    (
                        pnValue IN NUMBER
                    )

RETURN NUMBER
IS
BEGIN
    INSERT INTO T_TABLE( K_KEY, V_VALUE )     VALUES ( SEQ_TABLE.NEXTVAL, pnValue )     RETURNING K_KEY INTO pnNewKey;

    RETURN pnNewKey;
END domainWriteQuery;

"Lachlan Pitts" <Lachlan_Pitts_at_softworks.com.au> wrote in message news:3976492d_at_grissom...
> G'day people,
>
> New problem for a new day....
>
> Any ideas what is wrong with this picture?
> It compiles but at runtime complains of "SQL Statement not ended";
>
> FUNCTION domainWriteQuery
> (
> pnValue IN NUMBER,
> pnNewKey OUT NUMBER )
> IS
> BEGIN
> INSERT INTO T_TABLE( K_KEY, V_VALUE )
> VALUES ( SEQ_TABLE.NEXTVAL, pnValue )
> RETURNING K_KEY INTO pnNewKey;
> END domainWriteQuery;
>
> Thanks in advance,
>
> Lachlan Pitts
>
>
>
Received on Thu Jul 20 2000 - 00:00:00 CDT