strange SP ???

From: Leslie Lu <leslie_y_lu_at_yahoo.com>
Date: Mon, 23 Jul 2001 11:55:36 -0700
Message-ID: <F001.00352564.20010723113934@fatcity.com>

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

Received on Mon Jul 23 2001 - 13:55:36 CDT