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>
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