Re: How to execute a SP at Forms and commit its changes
Date: Sun, 16 Mar 2003 00:49:55 +0800
Message-ID: <b4vlr6$p0m$1_at_mail.cn99.com>
[Quoted] Call the procedure in POST-FORM-COMMIT trigger, which will fire before Forms do a database commit.
"ariadnedbka" <member25721_at_dbforums.com> 写入消息新闻
: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 - 17:49:55 CET