Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: What's wrong with my SQL???

Re: What's wrong with my SQL???

From: Adrian Billington <billiauk_at_yahoo.co.uk>
Date: 14 Aug 2002 05:23:35 -0700
Message-ID: <dee17a9f.0208140423.6f806130@posting.google.com>


Wells

Your Native Dynamic SQL syntax is incorrect...

The line :-

>> sql_txt := 'select max(seqno) + 1 SEQNO from ' || v_seq_owner || '.' ||
>> v_table_name || ' Returning SEQNO into :1';

...should read :-

sql_txt := 'select max(seqno) + 1 SEQNO from '||v_seq_owner||'.'||v_table_name;

The line:-
>> EXECUTE IMMEDIATE sql_txt RETURN INTO seqno_val;

...should read :-

EXECUTE IMMEDIATE sql_txt INTO seqno_val;

Regards

Adrian Received on Wed Aug 14 2002 - 07:23:35 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US