Database Trigger Error [message #371048] |
Thu, 17 August 2000 12:12 |
Ahuja
Messages: 3 Registered: August 2000
|
Junior Member |
|
|
I am using
Oracle8i Personal Edition Release 8.1.5.0.0 - Production.
I created a database trigger.....
CREATE OR REPLACE TRIGGER change_hist
AFTER CREATE ON SCOTT.SCHEMA
DECLARE
BEGIN
if DICTIONARY_OBJ_TYPE in ('PROCEDURE', 'FUNCTION',
'PACKAGE', 'PACKAGE BODY', 'TYPE') then
-- Store old code in SOURCE_HIST table
INSERT INTO SOURCE_HIST
SELECT sysdate, user_source.* FROM USER_SOURCE
WHERE TYPE = DICTIONARY_OBJ_TYPE
AND NAME = DICTIONARY_OBJ_NAME;
end if;
EXCEPTION
WHEN OTHERS THEN
raise_application_error(-20000, SQLERRM);
END;
Now when I create a procedure p1.....
create or replace procedure p1 as
a1 number;
begin
a1 := 23;
end;
It gives me error......
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-20001: ORA-00904: invalid column name
ORA-06512: at line 17
When I disable the trigger , it works fine, there is some problem in trigger.
Please help !
Thanks
|
|
|