Home » SQL & PL/SQL » SQL & PL/SQL » Handling exceptions (Oracle 9i)
Handling exceptions [message #388844] Thu, 26 February 2009 06:21 Go to next message
ramesh55.sse
Messages: 262
Registered: December 2008
Location: Hyderabad
Senior Member
How can we handle exceptions in pl/sql block that contains 5 select statements in that 1,2,4 are raising exceptions how can u handle those exceptions with out writing separate blocks?
Re: Handling exceptions [message #388847 is a reply to message #388844] Thu, 26 February 2009 06:30 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If you want to (try to) execute all statements, you can't.
You can put 4 blocks in a superblock.

Regards
Michel

[Updated on: Thu, 26 February 2009 06:30]

Report message to a moderator

Previous Topic: java.sql.SQLException: Protocol violation (merged)
Next Topic: How views works?
Goto Forum:
  


Current Time: Sat Dec 10 18:31:47 CST 2016

Total time taken to generate the page: 0.07669 seconds