Create a trigger in oracle to call stored procedures with Parameters

Oracle creation trigger call with parameters stored procedure Background: when inserting data into a data table, the defined stored procedure is called to parse the inserted data in xml format. The Stored Procedure contains parameters. solution: create a trigger for inserting data tables and call the Stored Procedure www.2cto.com in the trigger: see the previous blog article oracle to use the stored procedure to parse xml string insert statement: insert into t_xml (2, '<item> <cpu_name> name1 </cpu_name> <value> 80% </value> </item>') trigger creation: create or replace trigger TRG_t_PARSE before insert on t_xml referencing for each rowdeclare -- local variables here -- pragma autonomous_transaction; -- for autonomous transactions, subtransactions can have commitbegin p_parse (: new. id); -- call the stored procedure and pass the parameter: new. id -- commit; endTRG_t_PARSE;