Home » SQL & PL/SQL » SQL & PL/SQL » Exiting from sqlplus when there is any errors while compiling pl/sql programs
Exiting from sqlplus when there is any errors while compiling pl/sql programs [message #274223] Mon, 15 October 2007 02:30 Go to next message
rolex.mp
Messages: 161
Registered: February 2007
Senior Member
I am connecting to sqlplus from unix and I am executing a pl/sql script . Now if I get some error while compiling a procedure, package, function or any sql statement I want to exit sqlplus.

whenever sqlerror works only for sql statements but not for plsql

I dont want to query user_errors table and then throw some exception depending on the same .

Is there any command available or any easier way to solve this problem ?

Re: Exiting from sqlplus when there is any errors while compiling pl/sql programs [message #274224 is a reply to message #274223] Mon, 15 October 2007 02:34 Go to previous message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No.

Regards
Michel
Previous Topic: creating sequences for all tables in the database at a time
Next Topic: index-table dependency
Goto Forum:
  


Current Time: Mon Dec 05 09:03:24 CST 2016

Total time taken to generate the page: 0.18822 seconds