Re: quit or exit within PL/SQl

From: Tobias Hitzfeld <Hitzfeld_at_Schoepflin.de>
Date: 1997/07/24
Message-ID: <33D750E0.CFFE4B61@Schoepflin.de>#1/1

--------------B765B5C05BD9604456FA1946
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

rob joss wrote:

> While running PL/SQL anonymous blocks , is there a package function
> available that will let you force a quit or an exit to the operating
> system prompt.  I have tried DBMS_SQL.parse with an 'exit ' or 'quit'
> and it generates an exception.
>
> These blocks are being run from within sqlplus on a unix server and I
> want to force an exit for sqlplus when a critical package procedure
> fails.  If this can be done from within the package procedure which
> inserts into an error log, then several PL/sql anonymous procedures do
>
> not need to be modified.

Dear Rob!
Just try it with

Sql*Plus> whenever sqlerror exit sql.sqlcode
Sql*Plus> ... (your pl/sql block)
Sql*Plus> ... exception when x raise_application_error(-20001,'Your

Errortext',true); -- true only if you want the error stack Sql*Plus> ...end;

If there occurs the error, Sqlplus will end because of the whenever sqlerror setting.

Hope, this will help. ;-)

Tobias Hitzfeld

--------------B765B5C05BD9604456FA1946
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit

<HTML>
<BODY TEXT="#000000" BGCOLOR="#3333FF" LINK="#66FFFF" VLINK="#800040" ALINK="#FF0000">
rob joss wrote:
<BLOCKQUOTE TYPE=CITE>While running PL/SQL anonymous
blocks , is there a package function
 available that will let you force a quit or
an exit to the operating
 system prompt.  I have tried DBMS_SQL.parse
with an 'exit ' or 'quit'
 and it generates an exception.

These blocks are being run from within sqlplus
on a unix server and I
 want to force an exit for sqlplus when a critical
package procedure
 fails.  If this can be done from within
the package procedure which
 inserts into an error log, then several PL/sql
anonymous procedures do
 not need to be modified.</BLOCKQUOTE>
Dear Rob!
 Just try it with

Sql*Plus> whenever sqlerror exit sql.sqlcode
 Sql*Plus> ... (your pl/sql block)
 Sql*Plus> ... exception when x raise_application_error(-20001,'Your
Errortext',true); -- true only if you want the error stack
 Sql*Plus> ...end;

If there occurs the error, Sqlplus will end because
of the whenever sqlerror setting.

Hope, this will help.  ;-)

Tobias Hitzfeld
</BODY>
</HTML>

--------------B765B5C05BD9604456FA1946-- Received on Thu Jul 24 1997 - 00:00:00 CDT