Hi All,
Apex version is 22.1.0 DB version 19
We are moving from Oracle Forms to Oracle Apex. We have several database packages which has row level inserts, updates, roll backs and deletes. Many logic uses the number of records to do the commit. Issue with going with Apex Autocommit (each dml is automatically committed) where as Forms maintain the session and commit happens only when explicit commit is issued.
We are kind of stuck to decide whether
a) we should re write this logic for the APEX and call the packages from APEX
b) Apex calls a dbms_scheduler Job which runs a host command invokes a sql session and then run the package from that sql session. Since this sql session is different from the APEX sql, this wont have the AUTO Commit issue.
Has any of you come across this issue?. Would like to hear the pros and cons for both the methods.
Thank you
Alex