Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: What's wrong with my SQL???
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
![]() |
![]() |