Re: How do I commit in a PL/SQL procedure in Forms 4.5?

From: Geoff White <whiteg_at_ccis.adisys.com.au>
Date: Tue, 22 Jun 1999 16:38:39 +0800
Message-ID: <376F4B8F.BB2972C3@ccis.adisys.com.au>

Scotto! wrote:

> Hi,
>
> I have a block that is a non-base table block. I take some
> input from the users and then based on that, I run a PL/SQL
> that inserts rows into one table. Pretty simple. I have a submit
> button that has the PL/SQL in a when-button pressed trigger.
> When I just go into sqlplus and run it, I would put a commit at the
> end. But in Forms, I get a message that says Nothing to save (or no
> changes to save - something like that.)
>
> I am now suppressing the message, but there should be a way
> to commit. I tried commit_form also with the same results.
>
> Thanks very much in advance.
> Scott G.
> IKEA North America

Suppressing the message is how I handle this. I have the 3 lines of code in a procedure and just call that. Another way to do it is to use the forms_ddl built-in do perform a database commit.

HTH
Geoff Received on Tue Jun 22 1999 - 03:38:39 CDT