Re: passing sql more than 40K in Plsql
- From: Connor McDonald <hamcdc@xxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 12 Apr 2005 13:29:09 +0100 (BST)
check out dbms_sql. It has a varchar2s type which is a table of varchar2.
hth
connor
--- Sanjay Mishra <smishra_97@xxxxxxxxx> 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
>
> --
> //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@xxxxxxxxx
"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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
