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

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 Received on Mon Jun 21 1999 - 23:05:13 CDT