Hello
Oracle 11g
Forms v11
Weblogic
I'm dealing with a problem that I'll try to explain:
a) In BLOCK ITEMS, inside exec_qry trigger, there is an INSERT (insert into....) into TABLE TEMP_TABLE
b) Next, GO_BLOCK SHOW_TEMP, exec_qry, and block is filled with the data previously inserted
c) do_key('COMMIT_FORM');
d) on SISTEMA.KEY-COMMIT, i have insert into TABLE_REAL as select from temp_table
But no data is inserted
I development environment the form is working as it should (insert into as select works), in a production environment no.
I assume the TEMP_TABLE is empty because data is not commited(?).
Is there some parameter, either in database or weblogic, that might mess with the way the transactions are handled?