IT Forums - Debugging oracle packages while the package is executed from another executable in wi

09-30-2004, 02:49 PM

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

K. Friday

10-02-2004, 07:31 AM

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@yahoo.com> wrote in message
news:ad620e8d.0409301449.6f80c2ec@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

The MyLounge.com forum is intended for informational use only and should not be relied upon and is not a substitute for any advice. The information contained on MyLounge.com are opinions and suggestions of members and is not a representation of the opinions of MyLounge.com. MyLounge.com does not warrant or vouch for the accuracy, completeness or usefulness of any postings or the qualifications of any person responding. Please consult a expert or seek the services of an attorney in your area for more accuracy on your specific situation. Please note that our forums also serve as mirrors to Usenet newsgroups. Many posts you see on our forums are made by newsgroup users who may not be members of MyLounge.com Term of Service