2 Replies Latest reply on May 15, 2019 10:35 AM by Zlatko Sirotic

    POST; in oracle forms 12C

    3634158

      Hi All,

       

      Does anyone familiar with the POST; changed in the forms 12C?

       

      POST; before 12C is a default oracle forms command for the temporary commit of the data in to the database.

       

      In forms 12C does it stands same or any changes??

        • 1. Re: POST; in oracle forms 12C
          cormaco

          This is from the Help of Forms [64 Bit] Version 12.2.1.3.0 (Production):

          POST Built-in

           

           

          Description

          Writes data in the form to the database, but does not perform a database commit. Oracle Forms first validates the form. If there are changes to post to the database, for each block in the form Oracle Forms writes deletes, inserts, and updates to the database.

           

          Any data that you post to the database is committed to the database by the next COMMIT_FORM that executes during the current Runform session. Alternatively, this data can be rolled back by the next CLEAR_FORM.

           

          • 2. Re: POST; in oracle forms 12C
            Zlatko Sirotic

            As far as I know (and we have Forms 6i modules that use POST, which we successfully put on Forms 12c a few years ago), the POST command did not change.

             

            But now there is a difference between COMMIT and COMMIT_FORM, ROLLBACK and CLEAR_FORM.

            Look at:

            https://community.oracle.com/message/14862557#14862557

             

            Regards,

            Zlatko