Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: reference cursors

Re: reference cursors

From: Connor McDonald <hamcdc_at_yahoo.co.uk>
Date: Thu, 29 Jan 2004 23:20:38 +0000 (GMT)
Message-ID: <20040129232038.64130.qmail@web25209.mail.ukl.yahoo.com>


Depends what is in your procedure. If it just opens the ref cursor, then the work (and hence the 60 seconds) will come from the fetching. Oracle can be quite smart by doing almost no work until the first fetch call is issued (after all, if you never do the first fetch, there is no point in Oracle doing the work).

hth
Connor


Connor McDonald
Co-author: "Mastering Oracle PL/SQL - Practical Solutions" - available now
web: http://www.oracledba.co.uk
web: http://www.oaktable.net

email: connor_mcdonald_at_yahoo.com

"GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day"



BT Yahoo! Broadband - Free modem offer, sign up online today and save 80 http://btyahoo.yahoo.co.uk

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Thu Jan 29 2004 - 17:20:38 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US