Re: PL/SQL errors...

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

-- 
Hans Forbrich                           
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com   
*** I no longer assist with top-posted newsgroup queries ***