Re: PL/SQL 8.1.6 : RETURNING CLAUSE problems

From: Oleg Kuzmin <kuzmin_at_hotmail.com>
Date: 2000/07/19
Message-ID: <sncm4rc36tt51@corp.supernews.com>#1/1

Greetings!

One workaround would be the following:
 FUNCTION domainWriteQuery

                     (
                         pnValue IN NUMBER,
                         pnNewKey OUT NUMBER )

 IS
 BEGIN

     INSERT INTO T_TABLE( K_KEY, V_VALUE )
     VALUES ( SEQ_TABLE.NEXTVAL, pnValue );

     SELECT MAX(K_KEY) INTO pnNewKey FROM T_TABLE;

 END domainWriteQuery;

MAX conditions may differ for your system, but the logic is the same.

Oleg

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 Wed Jul 19 2000 - 00:00:00 CDT