Re: Database Triggers

Posted by Phindile on Nov 07, 2017; 8:49am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Database-Triggers-tp4289p4291.html

Thanks for your response,

1) HRPERSAL_USER is the owner of the trigger

2) I actually tried that, and the trigger does compile but with errors. When I do an insert on DUMMY_PER_GEN_DET, it doesn't update on DUMMY_PERSON.

These are the errors I'm getting on the logging page - log

SEVERE	701	5056220	org.openide.util.RequestProcessor$Processor	Error in RequestProcessor oracle.ideimpl.usages.UsagesTrackerImpl$2
SEVERE	127	0	org.openide.util.RequestProcessor$Processor	Error in RequestProcessor oracle.ideimpl.usages.UsagesTrackerImpl$3

 

On Tue, Nov 7, 2017 at 10:27 AM, ErmanArslansOracleBlog [via Erman Arslan's Oracle Forum] <[hidden email]> wrote:

1)Who is the owner of the trigger?
2)what happens when you create trigger with the following ->

create or replace TRIGGER DUMMY_HRPERSAL_TRIGGER AFTER INSERT OR UPDATE ON DUMMY_PER_GEN_DET FOR EACH ROW WHEN (new.R_INDICATOR = '0')
BEGIN INSERT INTO HR_USER.DUMMY_PERSON (PERSALNO,COL_SEQ) VALUES (:new.PERSALNO,DUMMY_HRPERSAL_SEQ.NEXTVAL); END;

(change - HR_USER.DUMMY_PERSON)

---

If you reply to this email, your message will be added to the discussion below:

http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/Database-Triggers-tp4289p4290.html

To unsubscribe from Database Triggers, click here.
NAML