DBMS_SQL will not work with SQL statement > 32K

Is there any way to execute dynamic DDL from PL/SQL when the DDL statement is larger than 32K?

We are writing a PL/SQL function that will create Audit Trail like Triggers for all of the tables in our database.

The PL/SQL function creates "CREATE TRIGGER..." statements based on information in the system_tables and then executes the statements using the DBMS_SQL package.

The problem is that in some cases, the "CREATE TRIGGER..." statement becomes larger than 32K and cannot fit in a VARCHAR2 or be passed to the DBMS_SQL.PARSE function.

Any ideas?

Thanks,
Kevin

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Dec 03 1999 - 14:04:49 CST