Eitan wrote:
> Well,
> I didn't know about execute immediate.
> (Is it simplier ? any sample , please).
> (for oracle 8i and greater).
>
> Thanks :)
Easier but lacking some functionality that can only be accomplished
using the DBMS_SQL built-in package. One example of which is
executing a PL/SQL table which can contain an executable statement
up to 4GB in size (perhaps larger with 10gR2 though I've not tested
it above 4GB).
--
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Sun Mar 12 2006 - 12:40:26 CST
