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
