Re: From 10g, "SQL Statement Length" description disappeared....

From: Richard Franklin <richard_p_franklin_at_yahoo.com>
Date: 5 Sep 2004 17:48:50 -0700
Message-ID: <d24db709.0409051648.11d6dfb3@posting.google.com>

> > I think this newsgroup is the incorrect address for such questions, as
> > probably no one ever has built or needed to build a 64k statement.
> > Please followup with Oracle support, or better still, revise your code
> > and your practices, you ever end up in such a situation.
> > Why does the SQL languiage have views?

> > --
> > Sybrand Bakker, Senior Oracle DBA
>
> Actually I have been in situations where sending single SQL statements
> to the database in the megabyte range was not unusual ... constituted
> about 7-8% of all DML.
>
> The solution, as I have posted here before, was to use DBMS_SQL's
> ability to execute a PL/SQL table. The source code for this can be
> found at: http://www.psoug.org/reference/dbms_sql.html.

Daniel - thx very much, I was very interested in exactly this context...excellent!

/rpf Received on Sun Sep 05 2004 - 19:48:50 CDT