Exception in ProcC

It stupid question. How can I handle exception thrown from database procedures (packages) in ProcC code.
Below is part of some package implementation.

procedure err_srv(err_nr number, err_txt varchar2) is begin

    raise_application_error( C_USER_EXCP + err_nr, err_txt ); end err_srv;

procedure procName1(

    p_curBM out BMCursorType )
is

    ID                      constant varchar(32) := 'procName: ';

    open p_curBM for

       select b.field1,
              b.field2
         from BM b
        where b.field3 = 'N'
        order by 1;

exception

    when others then

       err_srv(C_PROC_ERR, ID||'others: '||sqlcode||'/'||sqlerrm); end procName2;

procedure procName2 (........)
begin

   begin
     select.....;

   exception

      when no_data_found then
       err_srv(-3, 'text' );

exception

   when others then

         raise;
end procName2;

I need catch exception thrown from such package. I'm completely newbie.

Thanks in advance,

Robert Received on Wed May 26 2004 - 19:06:10 CEST