Home » RDBMS Server » Server Administration » Database Trigger Error
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
Previous Topic: Re: Oracle knowing person
Next Topic: Using Archive Log files to replicate database
Goto Forum:
  


Current Time: Thu Mar 28 11:33:48 CDT 2024