Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Temporary tables populated slow from report

Status
Not open for further replies.

nagornyi

MIS
Nov 19, 2003
882
US
I created several stored PL/SQL procedures to populate temporary tables off which I do my report. If executed directly on the DB (Oracle 9i, from TOAD) the procedures take seconds to execute. However, when I call the same procedures from the report trigger, they work very very slow (half an hour or so). What may be causing such a strange behaviour?
Thanks.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top