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?
Desktop
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.
Sort by Trending