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
kipp@plancknet.com
Messages: 25
Registered: September 2006
Junior Member
Hello.
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!
Kipp
Re: SQL error checking, need help. [message #221874 is a reply to message #221872] Wed, 28 February 2007 14:02 Go to previous message
smartin
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: Tue Dec 06 14:14:07 CST 2016

Total time taken to generate the page: 0.10243 seconds