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

From: Adrian Billington <billiauk_at_yahoo.co.uk>
Date: 14 Aug 2002 05:26:06 -0700
Message-ID: <dee17a9f.0208140426.4187fcb5@posting.google.com>

Wells

Your NDS syntax is incorrect in a couple of places...

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:26:06 CDT