Lachlan Pitts <Lachlan_Pitts_at_softworks.com.au> wrote in message
news:3976c3b4_at_grissom...
According to the manual, the correct syntax is
> INSERT INTO T_TMP_RETURNING ( K_KEY, N_VALUE )
VALUES(
> SELECT SEQ_TMP_RETURNING.NEXTVAL, pnValue
> FROM DUAL
)
> RETURNING K_KEY INTO pnoKey;
because the returning_clause is a part of values_clause, which can contain
subquery.
But the syntax diagram here has a mistake, and I had no success, trying
subquery in values_clause (8.1.6 for UnixWare).
Alexander I. Doroshko, Bank "Grant", Kharkov, Ukraine
aid_at_grant.kharkov.ua
Received on Thu Jul 20 2000 - 00:00:00 CDT
