Tom Kyte suggests in his book that there is no way to do this short of not
handling the exceptions. (p1181) if I read him correctly.
"Vasily Poushko" <vasily_at_genesyslab.ru> wrote in message
news:aa6bqk$i5t$1_at_octopus.co.ru...
> Your answer is not correct.
> Please check it by yourself.
>
> "Sunil" <sunil_franklin_at_hotmail.com> wrote in message
> news:diyx8.4$Cv2.110_at_news.oracle.com...
> > Will 'format_call_stack' help. It gives you the line number .
> >
> >
> >
> >
> > "Vasily Poushko" <vasily_at_genesyslab.ru> wrote in message
> > news:aa6aar$hgi$1_at_octopus.co.ru...
> > > How to get current program line number in exception?
> > >
> > > Hello. I'd like to get current program line number, where raised
> > exception.
> > >
> > > My code is:
> > > create or replace procedure qqq
> > > as
> > > n varchar2(1) := '12';
> > > begin
> > > null;
> > > exception when others
> > > dbms_out.put_line(sqlerrm);
> > > end;
> > > /
> > >
> > > execute qqq;
> > >
> > > output will be:
> > > ORA-06502: PL/SQL: numeric or value error: character string buffer too
> > small
> > >
> > > but I would like to get:
> > > ORA-06502: PL/SQL: numeric or value error: character string buffer too
> > small
> > > ORA-06512: at "SCOTT.QQQ", line 2
> > > ORA-06512: at line 2
> > >
> > > How can I do this?
> > >
> > >
> > >
> >
> >
>
>
Received on Wed Apr 24 2002 - 10:43:49 CDT
