Home » SQL & PL/SQL » SQL & PL/SQL » SQL error checking, need help.
SQL error checking, need help. [message #221872] Wed, 28 February 2007 13:54 Go to next message
Messages: 25
Registered: September 2006
Junior Member
I have several SQL scripts (not PL/SQL) that do quite a bit of updating to a couple tables.
Is there anyway to check if a statement errors and then if it does exit?
Thanks in advance!
Re: SQL error checking, need help. [message #221874 is a reply to message #221872] Wed, 28 February 2007 14:02 Go to previous message
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
Senior Member
Check out the "whenever" statement in the SQL PLUS Documentation.
Previous Topic: display elapsed time within PL/SQL
Next Topic: Tablespace and tables
Goto Forum:

Current Time: Fri Apr 28 07:19:46 CDT 2017

Total time taken to generate the page: 0.05375 seconds