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: 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