In OO4O Automation, you can execute commands using asynchronous processing.
This enables you to execute SQL statements and PL/SQL blocks in non-blocking
mode. Non-blocking mode is an option of the CreateSQL method.
Non-Blocking Mode
In non-blocking mode, control is returned to the application immediately even
if the execution is not complete. This allows the application to execute other
tasks which are not dependent on the results of the last execution.
To enable non-blocking mode, pass in ORASQL_NONBLK option to CreateSQL while
creating the OraSqlStmt object. If this mode is not specified, the OraSqlStmt executes in blocking mode
(default behavior).
'Create the statement in NON-BLOCKING mode
OraSQL = Oradb.CreateSQL("delete from emp",ORASQL_NONBLK)
An OraSqlStmt object created in non-blocking mode executes in non-blocking
mode for the lifetime of the object.
·Checking the Status of a Non-Blocking Operation·Canceling a Non-Blocking Operation·Executing Multiple Queries in Asynchronous Mode·Limitations on Non-Blocking
