Cancel Method

Applies To

OSqlStmt

Description

This method is called to cancel a non-blocking operation that is underway on the OSqlStmt object. Valid only if the OSqlStmt object has been created with OSQLSTMT_NONBLK option.

Usage

oresult Cancel(void) const

Arguments

none

Remarks

The application can cancel a long running asynchronous operation by calling the Cancel method on the OSqlStmt object. The Cancel method will cancel the execution that is in progress.

Return Values

An oresult indicating whether the operation succeeded (OSUCCESS) or not (OFAILURE).

Errors are thrown as exceptions.

Example

This example uses try and catch blocks.

//try block

try

{

long ret;

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);

}

// To cancel an asynchronous execution

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

100" ,OSQLSTMT_NONBLK);

if ( ret != OSQL_SUCCESS )

cout << "Error " << osqlstmt.GetErrorText() << endl;

ret = osqlstmt.NonBlockingState();

if ( ret == OSQL_STILL_EXECUTING )

{

ret = osqlstmt.Cancel();

if ( ret != OSQL_SUCCESS )

cout << "Error " << osqlstmt.GetErrorText() << endl;

else

cout << "Cancel of non-block execution succesful" <<

endl;

}

}

//catch block

catch(OException oerr)

{

cout << "Exception while executing 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.