Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How do I commit in a PL/SQL procedure in Forms 4.5?
On Tue, 22 Jun 1999 16:38:39 +0800, Geoff White
<whiteg_at_ccis.adisys.com.au> wrote:
>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
>
Hi Geoff,
Thanks very much for the reply. I will try forms_ddl.
Take care,
Scott G.
Received on Wed Jun 23 1999 - 20:56:36 CDT