Re: Dynamic SQL

From: Daniel A. Morgan <dmorgan_at_exesolutions.com>
Date: Sat, 31 Mar 2001 01:43:40 -0800
Message-ID: <3AC5A6CC.49E9D970@exesolutions.com>

> Since Oracle 8i dbms_sql is obsolete and you should use native dynamic sql

I absolutely agree with one caveat. When executing SQL statements larger than 32K it is still necessary to use the DBMS_SQL package as it has the ability to write the statement to a SQL table and then execute it no matter what the size.

This ability does not exist inside of Native Dynamic SQL.

And lest you think no sane person would pass more than 32K into a procedure you are correct. But that is not stopping my current employer. <g>

Daniel A. Morgan Received on Sat Mar 31 2001 - 03:43:40 CST