Try putting the select in an enclosing block, ie: -
begin
SELECT my_id INTO v_temp
FROM my_tablee
WHERE my_id = v_number;
exception
when NO_DATA_FOUND then
do_something;
end;
use_v_temp;
HTH
David Lord
-Original Message-
Sent: 27 April 2001 15:41
To:
Try This. In this example you can handle the exception without exiting from
the procedure. The exception interrupts the process between the inner
begin-end block. The execution is continued after the inner begin-end block.
Procedure Something as
Begin
.
.
.
.
Begin