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

[Quoted] The problem on calling it in POST-FORM-COMMIT trigger is that I can't use ROLLBACK there, so it will commit the changes made by the stored procedure even if the procedure returns an error.

Originally posted by Gengmao
> Call the procedure in POST-FORM-COMMIT trigger, which will fire
> before Forms
> do a database commit.
>
> "ariadnedbka" дÈëÏûÏ¢ÐÂÎÅ
> :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/http://dbforums.com     

--
Posted via http://dbforums.com