NonBlockingState

Applies To

OSqlStmt

Description

This method is called to determine if SQL execution is still pending on this object.

Valid only if the OSqlStmt object has been created with OSQLSTMT_NONBLK option.

Usage

long NonBlockState(void) const

Arguments

none

Remarks

OSqlStmt created with OSQLSTMT_NONBLK option provides the ability to execute SQL statements and PL/SQL blocks in non-blocking mode. In the 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. The application can determine the status of the asynchronous execution by polling on NonBlockingState.

Return Values

OSQL_STILL_EXECUTING indicates that the execution is still in progress.

OSQL_SUCCESS indicates that the execution completed successfully.

Any errors are thrown as exceptions.

The application should poll till the execution completes with OSQL_SUCCESS or until the call results in an exception.

Example

This example uses try and catch blocks.

//try block

try

{

OStartup(OSTARTUP_MULTITHREADED);

osess.Open();

odb.Open(osess, "ExampleDB", "scott", "tiger");

if ( ! odb.IsOpen() )

{

cout << "Database not opened: " << odb.GetErrorText() <<

endl;

odb.Close();

return(-1);

}

// Set up a sql statement to execute in Non-Blocking mode

OSqlStmt osqlstmt(odb, "update junk set ichar='AGAIN' where iint >

100 ",OSQLSTMT_NONBLK);

long ret = OSQL_STILL_EXECUTING;

while ( ret == OSQL_STILL_EXECUTING )

{

ret = osqlstmt.NonBlockingState();

}

cout << "Statement executed succesfully in non-block mode"<< endl;

}

//catch block

catch(OException oerr)

{

cout << "Exception while executing in non-blocking mode : " <<
oerr.GetErrorText() << endl;

retVal = -1;

}

Additional examples can be found in ORACLE_BASE\ORACLE_HOME\oo4o\cpp. See About Sample Code and Applications.