Are You sure it is the RETURNING CLAUSE problem, not that of the
RETURN CLAUSE absence in Your FUNCTION definition?
Alexander I. Doroshko, Bank "Grant", Kharkov, Ukraine
aid_at_grant.kharkov.ua
Lachlan Pitts <Lachlan_Pitts_at_softworks.com.au> wrote in message
news:3976492d_at_grissom...
> 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;
Received on Thu Jul 20 2000 - 00:00:00 CDT