[ORACLE]
block_post=1
0 means switched off, 1 means switched on.
This entry controls how AUXORACL implements calls which update the database. If block_post=0 each call to update the database generates a separate SQL statement. If block_post=1, several separate updates are combined into one, and the update is done via a call to a stored procedure, the name of which is dependent on the set of updates to be performed. If the procedure does not exist on Oracle, auxoracl creates it and then executes the procedure again. In theory users could modify the stored procedure to implement additional constraints.
N.B. This option is only enabled when use_checksum is also set to 1.
Although the option currently defaults to 1 you are recommended not to use it until the DP4 database structure is finalised, as otherwise the stored procedure may be incorrect. We may change the implementation details of this feature, in future, to allow use of more sophisticated features of databases and it may also be extended to include auxsybas and auxwodbc