Re: Forms 4.5 commit

"FORMS_DDL('COMMIT');" will work.

"Matt B." <gtimatt_at_home.com> wrote in message news: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 28 2001 - 19:07:45 CET