|Oracle® Objects for OLE Developer's Guide
10g Release 1 (10.1)
Part Number B10118-01
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.
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.