Re: Forms 4.5 commit

I would change the state of the form/block. The real question though is, does your form do more than run this code? What I mean is does it also have the capability to insert, update or delete records via normal forms processing? If so, you will need to be careful about controlling your commits.

Chet West

"Mark Styles" <news_at_lambic.co.uk> wrote in message news:bl2lvtklte5snar4uamokcthcbs47pu1hv_at_4ax.com...
>
> I have an Oracle 4.5 form, which calls various stored procedures.
> Those procedures make database changes.
>
> My problem is Oracle Forms doesn't recognise that the procedures have
> made changes, so when I issue a commit (which gets auto-magically
> converted to a 'COMMIT_FORM'), I get the message 'no changes to be
> applied'.
>
> How can I force forms to do a commit? I could call a stored procedure
> which does a commit, but that's kinda ugly. Or I could force the form
> into a Changed state, but that's not very pretty either.
>
> Thanks.
>
Received on Wed Nov 21 2001 - 03:35:07 CET