Re: How to execute a SP at Forms and commit its changes
Date: Sat, 15 Mar 2003 00:14:48 GMT
Message-ID: <Yfuca.1652$z_3.727462_at_news1.news.adelphia.net>
What triggers the original commit?
"ariadnedbka" <member25721_at_dbforums.com> wrote in message
news:2644134.1047659109_at_dbforums.com...
>
> After executing a insert/update/delete and commiting a record from a
> table in a datablock, I have to run a PL/SQL stored procedure that will
> make changes in other tables.
> So far I found the best way to do it is to call the procedure from
> POST-DATABASE-COMMIT trigger.
> The problem is that the procedure doesn't execute a commit neither a
> rollback so I would have to do it at the Forms.
> But I cannot commit from this trigger because I get this message:
> "Illegal restricted procedure COMMIT in POST-DATABASE-COMMIT trigger"
>
> Can anybody please help me on when to run the stored procedure or how to
> commit its changes?
>
> Thanks very much!!
> Ariadne
>
> --
> Posted via http://dbforums.com
Received on Sat Mar 15 2003 - 01:14:48 CET