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: Ref cursor length limit...

Re: Ref cursor length limit...

From: Connor McDonald <hamcdc_at_yahoo.co.uk>
Date: Mon, 22 Nov 2004 00:33:00 +0000 (GMT)
Message-ID: <20041122003300.87721.qmail@web86908.mail.ukl.yahoo.com>


You're caught between the proverbial rock and hard place...

  1. use massive SQL stmts - you'll hit some sort of limit (perhaps IN-list items, total statement length, big parse times etc)
  2. use temp tables - got some redo issues there in most releases
  3. use PL/SQL tables - possible dubious explain plans

If you opt for (c), you might want to architect in some CARDINALITY hints et al to give the optimizer some better clues

hth
connor


Connor McDonald
Co-author: "Mastering Oracle PL/SQL - Practical Solutions" ISBN: 1590592174 web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: connor_mcdonald_at_yahoo.com

Coming Soon! "Oracle Insight - Tales of the OakTable"

"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"


                

Moving house? Beach bar in Thailand? New Wardrobe? Win 10k with Yahoo! Mail to make your dream a reality. Get Yahoo! Mail www.yahoo.co.uk/10k
--
http://www.freelists.org/webpage/oracle-l
Received on Sun Nov 21 2004 - 20:03:19 CST

Original text of this message

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