Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: strange SP ???
Leslie,
My guess is that the EXEC call to the SP is only opening the cursor
(meaning, parse only). Once you execute the 'print' statement, the fetch is
occurring.
I would look at the 'where' clause - basic sql tuning - to see if it
executes quickly. Cut and paste the select statement into a sql window to
see what is happening.
I am using ref cursors at my current project, and this seems to be how it
works here (using VB & ADO).
HTH
Tom Mercadante
Oracle Certified Professional
-----Original Message-----
Sent: Monday, July 23, 2001 3:40 PM
To: Multiple recipients of list ORACLE-L
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
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: NDATFM_at_labor.state.ny.us Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-LReceived on Mon Jul 23 2001 - 14:01:11 CDT
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
![]() |
![]() |