Hi all,
I have a SP which returns a refcursor. The SP
executes immediately, but when I do a print of the
refcursor, it takes about 2 minutes to return only 1
row!!!
SQL> var xx refcursor
SQL>exec
lp_ccgetcustaddracctbyacct_00('20034662',33,:xx);
(instantaneous)
SQL>print :xx (about 2 minutes !!!!)
Any suggestion??? Thank you very much.
Leslie
__________________________________________________
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/
LP_CCGETCUSTADDRACCTBYACCT_00.PRC
The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender directly and ask for it to be sent to you by private E-mail. This warning is inserted into all messages containing binary attachments which have been removed by ListGuru. If you have questions about this message, contact [EMAIL PROTECTED] for clarification.
