Oracle Trigger executing stored procedure after insert
Posted on 2006-06-29
I am working with an application that updates a FACT table in an oracle schema. I want to add a trigger to that FACT table that executes a stored procedure that moves the data from the preliminary FACT table to the final table in my star schema after the INSERT is complete. I am expecting millions of records. My stored procedure works correctly when executed by itself. The trigger appears to be causing the application to 'hang' when inserted records into the preliminary FACT table. I have tested the process without the trigger and it is successful and fast. Since I am only an Oracle coder 'wannabe', I'm sure that I am making a rookie mistake. Your assistance is greatly appreciated!
Trigger code is as follows:
CREATE OR REPLACE TRIGGER TR_TEST
AFTER INSERT OR UPDATE
REFERENCING NEW AS NEW OLD AS OLD