Re: passing sql more than 40K in Plsql

From: Connor McDonald <hamcdc_at_yahoo.co.uk>
Date: Tue, 12 Apr 2005 13:29:09 +0100 (BST)
Message-ID: <20050412122909.54514.qmail@web86906.mail.ukl.yahoo.com>

check out dbms_sql. It has a varchar2s type which is a table of varchar2.

hth
connor

• Sanjay Mishra <smishra_97_at_yahoo.com> wrote:
  > Hi
  >
  > Can somebody give me an example as how I can fetch a dynamic sql of more that 40K size in Plsql.
  > I think I need to store it in LOB dataype but looking for some example. What I am looking is to
  > open a Cursor with big SQL with several condition and UNION of aroung 20Pages. If somebody can
  > share any example of doing piecewise fetch or like using CLOB.
  >
  > TIA
  > Sanjay
  > __________________________________________________
  > Do You Yahoo!?
  > Tired of spam? Yahoo! Mail has the best spam protection around
  > http://mail.yahoo.com
  >
  > --
  > http://www.freelists.org/webpage/oracle-l
  >
  

Connor McDonald
Co-author: "Mastering Oracle PL/SQL - Practical Solutions" Co-author: "Oracle Insight - Tales of the OakTable"

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"

---

---

Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Apr 12 2005 - 08:33:10 CDT