Re: Very Large Dynamic SQL

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Mon, 20 Aug 2007 17:55:01 +0200
Message-ID: <46c9b955$0$422$426a74cc@news.free.fr>

"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 Received on Mon Aug 20 2007 - 10:55:01 CDT