Oracle Objects for OLE
Release 9.0.1

Part Number A90173-01

Home

Book List

Contents

Master Index

Feedback

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.


 
Oracle
Copyright © 1996-2001, Oracle Corporation.

All Rights Reserved.

Home

Book List

Contents