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_at_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 CET

Original text of this message