Re: COMMIT; then "no changes to save"

The problem isn't that you have nothing to commit.

Forms is a strange beast. In order to issue a session level commit, you need to issue commit with server side interpreted PS/SQL.

FORMS_DDL('COMMIT'); --this should get you there.

Jim Limberatos (jlim_at_pangea.ca) wrote:
: I have a procedure in Form 4.5 whose job is to create a record containing
: information on an import. I want to post this record regardless of whether
: or not the import completes successfully and I also want users to know that
: an import is in progress, so it is necessary that I commit it before the
: import starts.
:
: If you don't understand the above then it doesn't matter -- my question is,
: what is wrong with the following?
:
: PROCEDURE x IS
:
: INSERT INTO import_session
: VALUES (blah blah blah);
:
: COMMIT; -- notice the commit right after the INSERT
:
: END;
:
: When this commit is executed I get Oracle telling me that there are
: 'no changes to save'. Huh??
:
: I must be missing something?
:
:

-- 
(: Joe Brown :)				      joe_at_apache.dtcc.edu
I believe Wine is going to be great if it ever gets finished. . .
I believe Linux _is_ great even though it's not finished! ! !
I believe you have my address.  :-)