create trigger issue

[maswien]

Hi,

We have an application from vendor that creates a trigger in the database when it's installed.

The SQL like following:

CREATE TRIGGER XXXX.TR_insert
BEFORE INSERT ON XXXX.COMP
FOR EACH ROW
BEGIN
SELECT XXXX.S_COMP.nextval
INTO YYYY.genT.unique_num
FROM dual;
:new.theKey:=YYYY.genT.unique_num;
END;

S_COMP: is a sequence owned by YYYY
genT: a package owned by YYYY

When this sql is run, oracle told me there is compile error, but when I type 'show error', I got nothing. I appreciate any kind of help!!

 

[dbtoo2001]

But who is running the trigger? They may need explicit grants to use the package / sequence.

 

[maswien]

Thanks dbtoo2001,

The SYS user who has the DBA role to run this setup script.

 

[dbtoo2001]

Maybe this will help?

http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a96590/adg10pck.htm#2475

 

[maswien]

I was prompted with a login window to ORACLEtechnology network. I don't have password for that

 

[dbtoo2001]

join. it's free.