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: Jaap W. van Dijk <j.w.vandijk.removethis_at_hetnet.nl>
Date: Wed, 14 Aug 2002 10:34:49 +0200
Message-ID: <u25kluk1le100agq9la5mf0as6q7l9pgjs@4ax.com> 





On Wed, 14 Aug 2002 01:25:17 -0400, "Wells"
<wshammou-NoSpam_at_optonline.net> wrote:



>...

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

>v_table_name || ' Returning SEQNO into :1';

>...




The RETURNING clause is only allowed and necessary for DML (UPDATE,
DELETE, INSERT).


Jaap.
Received on Wed Aug 14 2002 - 03:34:49 CDT












Original text of this message













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