Internal Error if Alterred a table
Hi All,
Oracle9i Enterprise Edition Release 9.0.1.1.1 - Production
PL/SQL Release 9.0.1.1.1 - Production
CORE 9.0.1.1.1 Production
TNS for 32-bit Windows: Version 9.0.1.1.0 - Production
NLSRTL Version 9.0.1.1.1 - Production
I am seeing a strange error...Please look into below example..
Code:
SQL> ed
Wrote file afiedt.buf
1 create or replace trigger Testing_Internal_Error after ALTER on schema
2 begin
3 insert into scott.test(created_by) values('hell');
4 --commit;
5 --dbms_output.put_line('Hello Abhay');
6 --RAISE_APPLICATION_ERROR(-20115, 'Abhay u r screwing DB');
7* end;
SQL> /
Trigger created.
SQL> alter table test modify created_by varchar(20);
alter table test modify created_by varchar(20)
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-06550: line 2, column 19:
PL/SQL: ORA-00600: internal error code, arguments: [12830], [SCOTT], [TEST], [], [], [], [], []
ORA-06550: line 2, column 1:
PL/SQL: SQL Statement ignored
SQL> alter trigger Testing_Internal_Error disable;
Trigger altered.
SQL> alter table test modify created_by varchar(20);
Table altered.
I have a trigger which monitors any ALTER commands issued on any object in particular schema & inserts record in reference table.
The above example is dummy example to reproduce the error.
what i see is that if we altered the table defination which is used in trigger to insert a record...it throws Internal error...
Rather it could have thrown some meaningful error.
Please if any body could explain this..
Thanks
Abhay