Re: Forms 4.5 commit
Date: Wed, 21 Nov 2001 03:16:12 GMT
Message-ID: <00FK7.19211$Sx.6322857_at_news1.elcjn1.sdca.home.com>
"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.
Someone asked a similar question a few weeks ago and the suggestion was to do (not sure exactly of the syntax - haven't tried this myself) a "FORMS_DDL('COMMIT');". See if FORMS_DDL can help you.
-Matt Received on Wed Nov 21 2001 - 04:16:12 CET