Re: Exiting PL/SQL

From: Sybrand Bakker <gooiditweg_at_sybrandb.verwijderdit.demon.nl>
Date: Wed, 09 Jun 2004 06:56:53 +0200
Message-ID: <s26dc097pggebjg2vmt55n3u9g78qttfiq@4ax.com>

On Tue, 8 Jun 2004 18:21:29 -0400, "Gordon" <gordon_t_wu_at_hotmail.com> wrote:

>
>"Gordon" <gordon_t_wu_at_hotmail.com> wrote in message
>news:bXqxc.365$Ny6.1071_at_mencken.net.nih.gov...
>> Hi Group,
>>
>> Is there a command in to terminate the PL/SQL program (and sqlplus)
>> immediately, then return an exit code to the host operating system?
>> Something like exit (-1) in C?
>>
>> Thanks
>>
>> Gordon
>>
>>
>
>I'm using Oracle 10g on RedHat 9, if it matters.
>

in sql*plus just use exit with a code (as documented) in pl/sql call raise_application_error with any negative number in the 20000s and don't trap it.

--
Sybrand Bakker, Senior Oracle DBA

Received on Tue Jun 08 2004 - 23:56:53 CDT