Hi !

Working on Oracle v8i with OS as Win2000.

!Could we use DDL commands in PL/SQL Blocks like in a Procedure as:

EXECUTE IMMEDIATE ALTER TRIGGER TRIG_NAME DISABLE;
OR
EXEC DBMS_SQL PACKAGE.

Could I have the syntax for this and what procedure/function are to be used with the above package.

Thanks & Regards,

Amit.