Jump to content

Multiple Exceptions in PL/SQL?


davej

Recommended Posts

Wow, I have a dumb question. I am trying to write some PL/SQL that queries two tables, but either or both queries can throw a NOT-FOUND exception. How the heck do I deal with that? There is no Try-catch in Oracle. I think I need sub-blocks. Yeah, that is probably it.

 

--EDIT--

 

Yeah, just nested sub-blocks.

Edited by davej
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...