Oracle Objects for OLE
Release 9.0.1

Part Number A90173-01


Book List


Master Index


Asynchronous Processing

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

Copyright © 1996-2001, Oracle Corporation.

All Rights Reserved.


Book List