Discussion Locked

Oracle exceptions

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
how do you build the exception handling portion of your program?

1 reply

by gary_w

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

This discussion is closed to new replies.