Help - Search - Members - Calendar
Full Version: is there try and catch in oracle query ?
Oracle DBA Forums > Oracle > Oracle Forum
goldsoft
hi

is there try and catch in oracle query

try
{
do some update
}
catch
{
if there was error go to here
}
burleson
Hi,

Boolean logic like this and the trapping of errors can be done in SQL*Plus, but you need to use PL/SQL, not SQL!

Please read: http://www.dba-oracle.com/t_ignoring_oracl...rs_in_plsql.htm

See this great reference for details:

http://www.rampant-books.com/book_0501_easy_plsql.htm
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2014 Invision Power Services, Inc.