NonBlockingState

See Also

Applies To

OraSQLStmt created with ORASQL_NONBLK option.

Description

Returns the status of the currently executing SQL. Returns ORASQL_STILL_EXECUTING if operation is still underway or 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.

Usage

status = OraSQL.NonBlockingState

if status = ORASQL_STILL_EXECUTING

MsgBox "Still in execution"

else

MsgBox "Execution completed successfully"

Arguments

None

Return Values

ORASQL_STILL_EXECUTING(-3123) or ORASQL_SUCCESS(0)

Errors are thrown as exceptions.