dbms_sql also has an array-fetch feature with
controllable array sizes that is not available in
native dynamic SQL.
--
Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
Practical Oracle 8i: Building Efficient Databases
Publishers: Addison-Wesley
Reviews at: http://www.jlcomp.demon.co.uk/book_rev.html
Daniel A. Morgan wrote in message <3AC5A6CC.49E9D970_at_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 - 07:53:48 CST
