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

Home -> Community -> Usenet -> c.d.o.misc -> How to get the returncode from a SQL-statement in a stored procedure

How to get the returncode from a SQL-statement in a stored procedure

From: J. Sultan <jsultan_at_tecs.de>
Date: 1996/12/14
Message-ID: <01bbe9e3$2c6b5420$0100007f@pc-jsultan>#1/1 







I'm working on a project with an Oracle 7 DB at my university and have the
following problem:


How can I obtain the returncode/result of an SQL-Statement in a stored
procedure?


There must be a sysvar or something that tells me if my Insert, Update,
etc. has succeeded.



Please give me hint. time is running up and the Oracle books online don's
say much about it.



Jan



ps: if possible, please send a cc to my mail adress, thanks
Received on Sat Dec 14 1996 - 00:00:00 CST












Original text of this message













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