Oracle Trigger Compilation Error [message #71851] |
Wed, 22 January 2003 01:54 |
Ersin
Messages: 5 Registered: January 2003
|
Junior Member |
|
|
We are writing a trigger and compile it in a third party oracle client software and then , For the first time it compiles succesfully , but when we make any changes to our trigger and try to compile it for the second time , it gives the "Ora-03113- end of file strem" and then "Ora-03114-oracle not connected" error. But if we drop the trigger and recreate the modified trigger on oracle , then it works.
We came face to face with this problem with every trigger we have written up to now. Our triggers are working well ( once we manage to compile )
Any help is valuable
|
|
|
|
Re: Oracle Trigger Compilation Error [message #71855 is a reply to message #71851] |
Wed, 22 January 2003 07:05 |
Ersin
Messages: 5 Registered: January 2003
|
Junior Member |
|
|
/*********************************************/
CREATE OR REPLACE TRIGGER ACT_INS
AFTER INSERT ON ACT
FOR EACH ROW
DECLARE
BEGIN
insert into baseline20.ACT values(:new.ACT_ID,:NEW.CAT_CODE,:NEW.OWNER_ID,:NEW.NAME,:NEW.UPDATE_SEQNR);
END ACT_INS;
/*********************************************/
our triggers are very simple ones..
I am sure they are not the cause of this problem...
|
|
|
Re: Oracle Trigger Compilation Error [message #71860 is a reply to message #71851] |
Wed, 22 January 2003 09:57 |
|
Mahesh Rajendran
Messages: 10707 Registered: March 2002 Location: oracleDocoVille
|
Senior Member Account Moderator |
|
|
you have defined the trigger on table ACT.
and you are inserting the records into table ACT owned by use baseline20.
right?
or
are the both the tables in the same schema?
if the table u are insert (from trigger) is on other schema, check the privs on the object to the current user.
|
|
|