Re: trigger,rollback,stored procedure

In article <4i4kqk$nd2@hpuniv.univ-lr.fr>, frivalla@soleil.univ-lr.fr says... : : :hi : :how can i insert data in a table (to retirve some details about the error) :,in a pl/sql stored procedure , after a raise exception (the insertion is :just after the raise exception) when this stored procedure is fired by a :triggers. : :My problem is when i fired a procedure by a trigger: :i've got the error -744. : :If i do an execute procedure without trigger : :i've got no problems !!!! : :thanks for your help !!!!! : : :-- : : :___________________________________________________________________ :frederic RIVALLAND :frivalla@cri.univ-lr.fr :La Rochelle : A normal problem is use, for update or insert, the same table in a trigger and a fired stored procedure with this trigger. A rule is ' you dont use the same table by a trigger and in the stored procedure fired by the trigger'. Sorry my english is very bad. Good luck.