Re: Very Large Dynamic SQL

From: Shakespeare <whatsin_at_xs4all.nl>
Date: Mon, 20 Aug 2007 17:35:34 +0200
Message-ID: <46c9b4d4$0$242$e4fe514c@news.xs4all.nl>

"Craig" <Craig_at_mailinator.com> schreef in bericht 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 !
>
>
>

Redesign? A dynamic sql > 32K? Do you have QA on your project?

Shakespeare Received on Mon Aug 20 2007 - 10:35:34 CDT