RE: Exit with usercode

Just use exit followed by the number you want to return. E.g.,

WHENEVER SQLERROR exit 1;

-----Original Message-----
From: Paul van Dijken [mailto:paul.vandijken_at_sema.nl] Sent: Thursday, May 11, 2000 2:27 AM
To: Multiple recipients of list ORACLE-L Subject: Exit with usercode

All,

Depending on the results of some queries, I want to exit a piece of SQL*Plus PL/SQL code with a user-defined number and return this number to the Unix environment. I know how to exit and to return the errorcode (Exit SQL.SQLCODE), but how do I return a user-defined number ?

Thanx,
Paul

-- 
Author: Paul van Dijken
  INET: paul.vandijken_at_sema.nl

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).