Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: quit or exit within PL/SQl
rob joss <rob_joss_at_lilly.com> wrote in article <33CE94CE.7391_at_lilly.com>...
> 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.
>
I would create a wrapper procedure that would call all of your sub
procedures.
This would take care of this for you.
> 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.
>
Have fun! Received on Tue Jul 22 1997 - 00:00:00 CDT