The following are limitations on non-blocking mode:
· When a non-blocking operation is underway on an OraSqlStmt object, you cannot
change the properties or attributes of this object as it can affect the
execution that is in progress.
· You cannot create a OraSqlStmt in Non-Blocking mode if there are other objects
that are already instantiated on the connection. In other words, creating an
OraSqlStmt object to execute in Non-Blocking mode only succeeds if no other
objects, such as OraDynaset and OraAQ, are currently active on the same database
session. The only exceptions are OraParameter objects and OraObjects. These are
permitted as they may be required for the non-blocking execution.
· While waiting for a non-blocking call to complete, the application cannot
invoke any methods or properties on the OraDatabase instance that contains this
OraSqlStmt. Applications can overcome this limitation by switching to a different
server context. Refer to the example in Executing Multiple Queries in Asynchronous Mode.