Oracle Forms

Dear ,

I've Form which is build based on integration between two system

First Tab retrieve data that 's existing in oracle , second tab retrieve the data existing in the other system (INFOR)...

There is Field status in both Tabs , requested that the status existing in INFO tab to be updating the status field in the oracle screen ..

i tried to commit the update in Pre- or Post Query , or post form & a lot of trigger but it says Commit is restricted

Now i'm calling the below procedure in the post Query , but i need to save data without showing the message "Do you want to save to the user ??", is that possible or is there other way to update this oracle status

with the INFOR status

SELECT Count(*) --- Check similarity between WO Request & Infor

             INTO  lv\_STATUS\_CHK

             FROM  XXDWTC\_WO\_HEADER\_ALL ,DBLINKtable@xxxxx 

             WHERE WO\_NUMBER = EVT\_CODE

             AND   WO\_STATUS = EVT\_STATUS

             AND   WO\_NUMBER = :XXDWTC\_WORK\_ORDER\_V.WO\_NUMBER ;

        IF lv\_STATUS\_CHK = 1 THEN --- means that the status of this work order is same as infor

        :XXDWTC\_WORK\_ORDER\_V.WO\_STATUS :=  :XXDWTC\_WORK\_ORDER\_V.WO\_STATUS ;

        :XXDWTC\_WORK\_ORDER\_V.WO\_STATUS\_DESC := :XXDWTC\_WORK\_ORDER\_V.WO\_STATUS\_DESC ;

       message('1');

     --   :SYSTEM.MESSAGE\_LEVEL := '25';

        ELSE

           :XXDWTC\_WORK\_ORDER\_V.WO\_STATUS := :XXDWTC\_WO\_R5EVENTS\_V.EVT\_STATUS  ;

           :XXDWTC\_WORK\_ORDER\_V.WO\_STATUS\_DESC := :XXDWTC\_WO\_R5EVENTS\_V.EVT\_STATUS\_DESC ;

            message('2');

        --     :SYSTEM.MESSAGE\_LEVEL := '0' ;

        END IF ;

Conclusion :::

Need to update the status in the first screen (Rounded in Red) , with the status in the second screen marked in yellow

Thanks