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

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