Re: DBMS_UTILITY.FORMAT_ERROR_BACKTRACE issue

Ziad wrote:
Thanks for the explanation.
hmm, so any quick solution for this if I need to capture the exact
line number? I tried to put a begin/end inside the cursor and have
the exception when others there. That worked and gave me the exact
line number, but we have over 40 cursors and it's a pain adding a
begin/end inside each cursor. It's also a pain switching them to open
loop fetch.

Well unless you have some antique version of Oracle you might want
to concentrate on getting rid of those cursor loops. They are slow
and inefficient.

Go to Morgan's Library at www.psoug.org and look up Array Processing.
A BULK COLLECT with a LIMIT clause and FORALL will improve your
performance and exception handling by a substantial margin.

There is a demo of NESTED LOOPs using array processing in the library
as well.
--
Daniel A. Morgan
University of Washington
damorgan@xxxxxxxxxxxxxxxx
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
.

Relevant Pages

  • Re: iPad mouse?
    ... cursor to an exact point on a screen with small fonts displayed in a ... "The game of professional investment is intolerably boring and over-exacting to ...
    (comp.sys.mac.advocacy)
  • Re: DBMS_UTILITY.FORMAT_ERROR_BACKTRACE issue
    ... I tried to put a begin/end inside the cursor and have ... That worked and gave me the exact ... It's also a pain switching them to open ...
    (comp.databases.oracle.server)
  • Re: Mouse problem
    ... I have been searching for months for help, ... exact same problem, and it is incredible the way people refer to and ... incredible how the cursor and pointer intermingle with each other). ...
    (microsoft.public.windowsxp.general)
  • Re: Reporting bugs... again
    ... cursor over the bars to get the exact numbers. ... Delphi/InterBase Weblog: http://blogs.teamb.com/craigstuntz ...
    (borland.public.delphi.non-technical)
  • Re: Cursor disappears in table
    ... I ran into the exact same problem today as c3000ca. ... long table consisting of 3 columns per page. ... I can see my cursor on ... Any fix would be greatly appreciated. ...
    (microsoft.public.word.application.errors)