Oracle® Objects for OLE Developer's Guide 11g Release 2 (11.2) for Microsoft Windows Part Number E12245-01 |
|
|
View PDF |
Applies To
"OraSQLStmt Object" created with ORASQL_NONBLK
option.
Description
Returns the status of the currently executing SQL as follows:
ORASQL_STILL_EXECUTING
If operation is still underway.
ORASQL_SUCCESS
If operation has completed successfully.
Any failures are thrown as exceptions.
The application can access the output parameters, if any, as in the blocking case, after successful execution of the SQL statement.
Usage
status = OraSQL.NonBlockingState if status = ORASQL_STILL_EXECUTING MsgBox "Still in execution" else MsgBox "Execution completed successfully"
Return Values
ORASQL_STILL_EXECUTING(-3123) or ORASQL_SUCCESS(0)
Errors are thrown as exceptions.
See Also: