Re: Very Large Dynamic SQL

Michel Cadot wrote:
> "Craig" <Craig_at_mailinator.com> a écrit dans le message de news: 13cjbnuk49cc3f4_at_corp.supernews.com...
> | 10gR2
> |
> | In my app, I've been using "OPEN some_cursor FOR some_dyn_sql ;"
> |
> | Now I'm facing a limitation problem.... I have to generate a VERY LARGE
> | dynamic SQL.
> | (bigger than "VARCHAR2(32767)")
> |
> | And "OPEN...FOR..." does not seem to take CLOB.
> |
> | What other options do I have ?
> |
> | Thanks !
> |
>
> Upgrade to 11g.
>
> Regards
> Michel Cadot

This functionality has been around since Oracle 7.3.4.

Look at the ability of dbms_sql.parse to parse dbms_sql.VARCHAR2S. I have a demo at: http://www.psoug.org/reference/dbms_sql.html that executes a statement originally created as a CLOB.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org