Re: Debugging oracle packages while the package is executed from another executable in window

From: K. Friday <res1b5v2_at_verizon.net>
Date: Sat, 02 Oct 2004 15:31:13 GMT
Message-ID: <5Rz7d.1879$cd1.712_at_trnddc03>


Depending on what you're trying to accomplish and assuming you can modify the package....

    trace with waits and binds
    pl/sql profiler (distributed with Oracle in the rdbms/admin dir)     util_file statements
    insert statements into a "debug" table

If its an Oracle Application pgk there may well be profile options available to turn on existing debug logging.

Ken

"RK" <rkochath_at_yahoo.com> wrote in message news:ad620e8d.0409301449.6f80c2ec_at_posting.google.com...
> Hi
> need help in debugging an oracle package using toad or any other tool
> when the package is executed from another executable connected to the
> database.
> thanks in advance
>
> rk
Received on Sat Oct 02 2004 - 17:31:13 CEST

Original text of this message