PL/SQL (MOSC)

MOSC Banner

Trigger on pay_element_entries_f

edited Mar 4, 2015 11:07AM in PL/SQL (MOSC) 3 commentsAnswered ✓

I am using a trigger to insert data from pay_element_entries_f for a specific element_type_id i.e. 298 .....

CREATE OR REPLACE TRIGGER JSAI_COFF_TRIG

after insert on  pay_element_entries_f for each row--pay_element_entries_f

declare

pragma autonomous_transaction;

p_nod number;

begin

    if :new.element_type_id=298 then

        JSAI_COFF_PROC_1(:new.element_entry_id,:new.element_type_id);

       commit;

    end if;

exception

when others then

dbms_output.put_line(sysdate||': SQLERRM:'||SQLERRM);

end;

This trigger is calling procedure below -

CREATE OR REPLACE PROCEDURE JSAI_COFF_PROC_1(P_ELEMENT_ENTRY_ID IN NUMBER,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center