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?

Report message to a moderator

Re: Handling exceptions [message #388847 is a reply to message #388844] Thu, 26 February 2009 06:30 Go to previous message
Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 09 19:48:11 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.