PL/SQL

I'm really not sure how will the exception be caught here...

begin

    delete from table_test ......
    insert into table_test .........

    and then a call to a procedure say test ( bla, bla );

exception

    when others ......

end;

procedure test ( bla, bla )
is
begin

      do something that triggers exception end;
-- no exception handling is done in this procedure

the question;

Will the uncaught raised exception in procedure test be caught in the calling routine or not ?

Appreciate some help.

cheers, Supian Received on Mon Dec 22 1997 - 00:00:00 CET