Re: Debug DDL trigger

I could be wrong, but I am pretty sure you are not allowed to issue commits - or rollbacks - in a trigger. That rules out not only the commits of your inserts, but especially your "execute immediate 'create table ...'" as all DDL imply a commit.

Herring Dave - dherri wrote:

> Folks,
> INSERT INTO dherri.aud_plsql_error_tb values ('SYS','Test: Before
> SELECT',1,sysdate);
>
> COMMIT;
>
>
> INSERT INTO dherri.aud_plsql_error_tb values ('SYS','Test: Within
> IF-TEST',v_table_count,sysdate);
>
> COMMIT;
>
>
>
> v_ddl_stmt := 'CREATE TABLE dherri.'||ora_dict_obj_name||'_bkp
> PCTFREE 0 AS SELECT * FROM dherri.'||ora_dict_obj_name||';';
>
> EXECUTE IMMEDIATE v_ddl_stmt;
>

-- 
Regards

Wolfgang Breitling
Centrex Consulting Corporation
www.centrexcc.com
--
http://www.freelists.org/webpage/oracle-l