Re: PL/SQL errors...

From: Maxim Demenko <mdemenko_at_gmail.com>
Date: Tue, 26 Jul 2005 21:26:39 +0200
Message-ID: <dc62pb$9mu$02$1@news.t-online.com>

HansF schrieb:
> On Tue, 26 Jul 2005 10:52:27 -0700, Joel interested us by writing:
>
>

>> 12           INSERT INTO LOG VALUES
>> 13           ((SELECT LOG_SEQ.NEXTVAL FROM DUAL),(SELECT
>>TRANSACTION_SEQ.CURRVAL FROM DUAL),
>> 14
>>UPPER(L_TNAME),L_TNAMEID,UPPER(L_CNAME),L_OLD,L_NEW,L_USER,SYSDATE,'');

>
>
> Why are you using the 'VALUES' clause when you have a subquery?
>
> http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/statements_913a.htm#2063932
>

In general, syntactically scalar subquery is allowed with INSERT INTO ... VALUES(...).
Something like INSERT INTO TABLE A VALUES((SELECT 2 FROM DUAL)) will work. Of course regarding OP, subquery selecting sequences are not allowed, so INSERT INTO TABLE A VALUES((SELECT SEQ.NEXTVAL FROM DUAL)) is syntactically wrong.

Best regards

Maxim Received on Tue Jul 26 2005 - 14:26:39 CDT