try this one

In Oracle side

create table where fields of this table are parameter of Your procedure

create insert trigger on this table and put there your procedure

if procedure return...