Re: How to execute a SP at Forms and commit its changes

ariadnedbka wrote:

> 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

Your post makes little sense.

You don't run a procedure after you commit a record change: It should be run before as part of the same transaction thus falling under, or rolling back, as part of that same transaction.

Please explain what business logic dictates that you violate the single-transaction rule.

Daniel Morgan Received on Sat Mar 15 2003 - 02:00:08 CET