Re: [Help]: PL/SQL Block "Handling NO_DATA_FOUND exception"

> origional pl/sql block that called the exception since you CANNOT use a
> goto label from the exception handler back to the calling block.

Goto from the excetion handler? Tsk, tsk, how could you even think of such a thing <g>.

You might like to think of:

begin
select
/*** if the select fails with nodatafound control passses to the

      exception handler ***/
do_'update';
exception
  do_insert;
end;

-- 
A Bientot
Marc