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: Query Help with Large Table
Next Topic: Two foreign keys for one column
Goto Forum:

Current Time: Sat Aug 19 02:26:55 CDT 2017

Total time taken to generate the page: 0.09398 seconds