General discussion

Locked

Oracle exceptions

By alexolan ·
how do you build the exception handling portion of your program?

This conversation is currently closed to new comments.

1 total post (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by Gary_W In reply to Oracle exceptions

put your query in a begin-end block, and add the exception code as follows:

begin
select....;
exception
when NO_DATA_FOUND then
message('no data found');
when others then
message('error');
end;

Gary

Back to Desktop Forum
1 total post (Page 1 of 1)  

Related Discussions

Related Forums