Statement Class

A Statement object is used for executing SQL statements. The statement may be a query returning result set, or a non-query statement returning an update count. Non-query SQL can be insert, update, or delete statements. Non-query SQL statements can also be DML statements (such as create, grant, and so on) or stored procedure calls.

A query, insert / update / delete, or stored procedure call statements may have IN bind parameters. A DML returning insert / update / delete statement or stored procedure call may have OUT bind parameters. Finally, a stored procedure call statement may have bind parameters that are both IN and OUT, referred to as IN/OUT parameters.

The Statement class methods are divided into three categories:

• Statement methods applicable to all statements

• Methods applicable to prepared statements with IN bind parameters

• Methods applicable to callable statements and DML returning statements with OUT bind parameters.

NEEDS_STREAM_DATA

PREPARED

RESULT_SET_AVAILABLE

STREAM_DATA_AVAILABLE

UNPREPARED

UPDATE_COUNT_AVAILABLE

addIteration()

After specifying set parameters, an iteration is added for execution.

void addIteration();

closeResultSet()

In many cases, it is desirable to immediately release a result set's database and OCCI resources instead of waiting for this to happen when it is automatically closed; the closeResultSet() method provides this immediate release.

void closeResultSet(
   ResultSet *resultSet);

resultSet

closeStream()

Closes the stream specified by the parameter stream.

void closeStream(
   Stream *stream); 

stream

disableCaching()

Disables statement caching. Used if a user wishes to destroy a statement instead of caching it. Effective only if statement caching is enabled.

void disableCaching();

execute()

Executes an SQL statement that may return either a result set or an update count. The statement may have read-able streams which may have to be written, in which case the results of the execution may not be readily available. The returned value is one of the following defined constants of the Statement class (see Table 10-37): PREPARED, UNPREPARED, RESULT_SET_AVAILABLE, UPDATE_COUNT_AVAILABLE, NEEDS_STREAM_DATA, and STREAM_DATA_AVAILABLE.

If only one OUT value is returned for each invocation of the DML returning statement, iterative executes can be performed for DML returning statements. If output streams are used for OUT bind variables, they must be completely read in order. The getCurrentStreamParam() method would indicate which stream needs to be read. Similarly, getCurrentIteration() would indicate the iteration for which data is available.

Status execute(
   const string &sql="");

Status execute(
   const UString &sql);

sql

executeArrayUpdate()

Executes insert/update/delete statements which use only the setDataBuffer() or stream interface for bind parameters. The bind parameters must be arrays of size arrayLength parameter. The statement may have read-able streams which may have to be written. The returned value is one of the following, and are defined as constants of the Statement class in Table 10-37: PREPARED, UNPREPARED, UPDATE_COUNT_AVAILABLE, NEEDS_STREAM_DATA, and STREAM_DATA_AVAILABLEThe returned value is one of the following:

If only one OUT value is returned for each invocation of the DML returning statement, array executes can be done for DML returning statements also. If output streams are used for OUT bind variables, they must be completely read in order. The getCurrentStreamParam() method would indicate which stream needs to be read. Similarly, getCurrentIteration() would indicate the iteration for which data is available.

Status executeArrayUpdate(
   unsigned int arrayLength);

arrayLength

executeQuery()

Execute a SQL statement that returns a ResultSet. Should not be called for a statement which is not a query, has streamed parameters. Returns a ResultSet that contains the data produced by the query.

ResultSet* executeQuery(
   const string &sql="");

ResultSet* executeQuery(
   const UString &sql);

sql

executeUpdate()

Executes a non-query statement such as a SQL INSERT, UPDATE, DELETE statement, a DDL statement such as CREATE/ALTER and so on, or a stored procedure call. Returns either the row count for INSERT, UPDATE or DELETE or 0 for SQL statements that return nothing.

unsigned int executeUpdate(
   const string &sql="");

unsigned int executeUpdate(
   const UString &sql);

sql

getAutoCommit()

Returns the current auto-commit state.

bool getAutoCommit() const;

getBfile()

Returns the value of a BFILE parameter as a Bfile object.

Bfile getBfile(
   unsigned int paramIndex);

paramIndex

getBlob()

Returns the value of a BLOB parameter as a Blob.

Blob getBlob(
   unsigned int paramIndex);

paramIndex

getBytes()

Returns the value of n SQL BINARY or VARBINARY parameter as Bytes; if the value is SQL NULL, the result is NULL.

Bytes getBytes(
   unsigned int paramIndex);

paramIndex

getCharSet()

Returns the character set that is in effect for the specified parameter, as a string.

string getCharSet(
   unsigned int paramIndex) const;

paramIndex

getClob()

Get the value of a CLOB parameter as a Clob. Returns the parameter value.

Clob getClob(
   unsigned int paramIndex);

paramIndex

getConnection()

Returns the connection from which the Statement object was instantiated.

const Connection* getConnection() const;

getCurrentIteration()

If the prepared statement has any output Streams, this method returns the current iteration of the statement that is being processed by OCCI. If this method is called after all the invocations in the set of iterations has been processed, it returns 0. Returns the iteration number of the current iteration that is being processed. The first iteration is numbered 1 and so on. If the statement has finished execution, a 0 is returned.

unsigned int getCurrentIteration() const;

getCurrentStreamIteration()

Returns the current parameter stream for which data is available.

unsigned int getCurrentStreamIteration() const;

getCurrentStreamParam()

Returns the parameter index of the current output Stream parameter that must be written. If the prepared statement has any output Stream parameters, this method returns the parameter index of the current output Stream that must be written. If no output Stream needs to be written, or there are no output Stream parameters in the prepared statement, this method returns 0.

unsigned int getCurrentStreamParam() const;

getCursor()

Gets the REF CURSOR value of an OUT parameter as a ResultSet. Data can be fetched from this result set. The OUT parameter must be registered as CURSOR with the registerOutParam() method. Returns a ResultSet for the OUT parameter value.

ResultSet * getCursor(
   unsigned int paramIndex);

paramIndex

getDatabaseNCHARParam()

Returns whether data is in NCHAR character set or not.

bool getDatabaseNCHARParam(
   unsigned int paramIndex) const;

paramIndex

getDate()

Get the value of a SQL DATE parameter as a Date object. Returns the parameter value; if the value is SQL NULL, the result is NULL.

Date getDate(
   unsigned int paramIndex) const;

paramIndex

getBDouble()

Gets the value of an IEEE754 DOUBLE column, which has been defined as an OUT bind. If the value is SQL NULL, the result is 0.

BDouble getBDouble(
   unsigned int paramIndex) = 0;

paramIndex

getDouble()

Get the value of a DOUBLE parameter as a C++ double. Returns the parameter value; if the value is SQL NULL, the result is 0.

double getDouble(
   unsigned int paramIndex);

paramIndex

getBFloat()

Gets the value of an IEEE754 FLOAT column, which has been defined as an OUT bind. If the value is SQL NULL, the result is 0.

BFloat getBFloat(
   unsigned int paramIndex) = 0;

paramIndex

getFloat()

Get the value of a FLOAT parameter as a C++ float. Returns the parameter value; if the value is SQL NULL, the result is 0.

float getFloat(
   unsigned int paramIndex);

paramIndex

getInt()

Get the value of an INTEGER parameter as a C++ int. Returns the parameter value; if the value is SQL NULL, the result is 0.

unsigned int getInt(
   unsigned int paramIndex);

paramIndex

getIntervalDS()

Get the value of a parameter as a IntervalDS object.

IntervalDS getIntervalDS(
   unsigned int paramIndex);

paramIndex

getIntervalYM()

Get the value of a parameter as a IntervalYM object.

IntervalYM getIntervalYM(
   unsigned int paramIndex);

paramIndex

getMaxIterations()

Gets the current limit on maximum number of iterations. Default is 1. Returns the current maximum number of iterations.

unsigned int getMaxIterations() const;

getMaxParamSize()

The maxParamSize limit (in bytes) is the maximum amount of data sent or returned for any parameter value; it only applies to character and binary types. If the limit is exceeded, the excess data is silently discarded. Returns the current max parameter size limit.

unsigned int getMaxParamSize(
   unsigned int paramIndex) const;

paramIndex

getNumber()

Get the value of a NUMERIC parameter as a Number object. Returns the parameter value; if the value is SQL NULL, the result is NULL.

Number getNumber(
   unsigned int paramIndex);

paramIndex

getObject()

Get the value of a parameter as a PObject. This method returns an PObject whose type corresponds to the SQL type that was registered for this parameter using registerOutParam(). Returns A PObject holding the OUT parameter value.

PObject * getObject(
   unsigned int paramIndex);

PObject * getObject(
   unsigned int paramIndex
   const UString &sqltyp);

paramIndex

sqltyp

getOCIStatement()

Get the OCI statement handle associated with the Statement.

LNOCIStmt * getOCIStatement() const;

getRef()

Get the value of a REF parameter as RefAny. Returns the parameter value.

RefAny getRef(
   unsigned int paramIndex);

paramIndex

getResultSet()

Returns the current result as a ResultSet.

ResultSet * getResultSet();

getRowid()

Get the rowid parameter value as a Bytes.

Bytes getRowid(
   unsigned int paramIndex);

paramIndex

getSQL()

Returns the current SQL string associated with the Statement object.

string getSQL() const;

getSQLUString()

Returns the current SQL UString associated with the Statement object; globalization enabled.

UString getSQLUString() const;

getStream()

Returns the value of the parameter as a stream.

Stream * getStream(
   unsigned int paramIndex);

paramIndex

getString()

Get the value of a CHAR, VARCHAR, or LONGVARCHAR parameter as an string. Returns the parameter value; if the value is SQL NULL, the result is empty string.

string getString(
   unsigned int paramIndex);

paramIndex

getTimestamp()

Get the value of a SQL TIMESTAMP parameter as a Timestamp object. Returns the parameter value; if the value is SQL NULL, the result is NULL

Timestamp getTimestamp(
   unsigned int paramIndex);

paramIndex

getUInt()

Get the value of a BIGINT parameter as a C++ unsigned int. Returns the parameter value; if the value is SQL NULL, the result is 0.

unsigned int getUInt(
   unsigned int paramIndex);

paramIndex

getUpdateCount()

Returns the current result as an update count.

unsigned int getUpdateCount() const;

getUString()

Return the value as a UString.

UString getUString(
   unsigned int paramIndex);

paramIndex

getVector()

Returns the column in the current position as a vector. The column at the position, specified by index, should be a collection type (varray or nested table). The SQL type of the elements in the collection should be compatible with the type of the vector.

void getVector(
   Statement *stmt,
   unsigned int paramIndex,
   std::vector<UString> &vect);

void getVector(
   Statement *stmt,
   unsigned int paramIndex,
   vector<BDouble> &vect);

void getVector(
   Statement *stmt,
   unsigned int paramIndex,
   vector<BFile> &vect);

void getVector(
   Statement *stmt,
   unsigned int paramIndex,
   vector<BFloat> &vect);

void getVector(
   Statement *stmt,
   unsigned int paramIndex,
   vector<Blob> &vect);

void getVector(
   Statement *stmt,
   unsigned int paramIndex,
   vector<Clob> &vect);

void getVector(
   Statement *stmt,
   unsigned int paramIndex,
   vector<Date> &vect);

void getVector(
   Statement *stmt,
   unsigned int paramIndex,
   vector<double> &vect);

void getVector(
   Statement *stmt,
   unsigned int paramIndex,
   vector<float> &vect);

void getVector(
   Statement *stmt,
   unsigned int paramIndex,
   vector<int> &vect);

void getVector(
   Statement *stmt,
   unsigned int paramIndex,
   vector<IntervalDS> &vect);

void getVector(
   Statement *stmt,
   unsigned int paramIndex,
   vector<IntervalYM> &vect);

void getVector(
   Statement *stmt,
   unsigned int paramIndex,
   vector<Number> &vect);

void getVector(
   Statement *stmt,
   unsigned int paramIndex,
   vector<RefAny> &vect);

void getVector(
   Statement *stmt,
   unsigned int paramIndex,
   vector<string> &vect);

void getVector(
   Statement *stmt,
   unsigned int paramIndex,
   vector<T *> &vect);

void getVector(
   Statement *stmt,
   unsigned int paramIndex,
   vector<T> &vect);

void getVector(
   Statement *stmt,
   unsigned int paramIndex,
   vector<Timestamp> &vect);

void getVector(
   Statement *stmt,
   unsigned int paramIndex,
   vector<u <Ref<T> > &vect);

void getVector(
   Statement *stmt,
   unsigned int paramIndex,
   vector<unsigned int> &vect);

stmt

paramIndex

vect

getVectorOfRefs()

This method returns the column in the current position as a vector of REFs. The column should be a collection type (varray or nested table) of REFs. Used with OUT binds and DML returning clauses.

void getVectorOfRefs(
   Statement *stmt,
   unsigned int colIndex,
   vector< Ref<T> > &vect);

stmt

colIndex

vect

isNull()

An OUT parameter may have the value of SQL NULL; wasNull() reports whether the last value read has this special value. Note that you must first call getxxx() on a parameter to read its value and then call wasNull() to see if the value was SQL NULL. Returns TRUE if the last parameter read was SQL NULL.

bool isNull(
   unsigned int paramIndex ) const;

paramIndex

isTruncated()

This method checks whether the value of the parameter is truncated. If the value of the parameter is truncated, then TRUE is returned; otherwise, FALSE is returned.

bool isTruncated(
   unsigned int paramIndex) const;

paramIndex

preTruncationLength()

Returns the actual length of the parameter before truncation.

int preTruncationLength(
   unsigned int paramIndex) const;

paramIndex

registerOutParam()

This method registers the type of each out parameter of a PL/SQL stored procedure. Before executing a PL/SQL stored procedure, you must explicitly call this method to register the type of each out parameter. This method should be called for out parameters only. Use the setxxx() method for in/out parameters.

• When reading the value of an out parameter, you must use the getxxx() method that corresponds to the parameter's registered SQL type. For example, use getInt or getNumber when OCCIINT or OCCINumber is the type specified.

• If a PL/SQL stored procedure has an out parameter of type ROWID, the type specified in this method should be OCCISTRING. The value of the out parameter can then be retrieved by calling the getString() method.

• If a PL/SQL stored procedure has an in/out parameter of type ROWID, call the methods setString() and getString() to set the type and retrieve the value of the IN/OUT parameter.

void registerOutParam(
   unsigned int paramIndex,
   Type type,
   unsigned int maxSize=0,
   const string &sqltype="");

void registerOutParam(
   unsigned int paramIndex,
   Type type,
   unsigned int maxSize=0,
   const UString &schName,
   const UString &sqltype);

paramIndex

type

maxSize

schName

sqltype

setAutoCommit()

A Statement can be in auto-commit mode. In this case any statement executed is also automatically committed. By default, the auto-commit mode is turned-off.

void setAutoCommit(
   bool autoCommit);

autoCommit

setBfile()

Set a parameter to a Bfile value.

void setBfile(
   unsigned int paramIndex,
   const Bfile &val);

paramIndex

val

setBinaryStreamMode()

Defines that a column is to be returned as a binary stream.

void setBinaryStreamMode(
   unsigned int colIndex,
   unsigned int size);

void setBinaryStreamMode(
   unsigned int colIndex,
   unsigned int size
   bool inArg);

colIndex

size

inArg

setBlob()

Set a parameter to a Blob value.

void setBlob(
   unsigned int paramIndex,
   const Blob &val);

paramIndex

val

setBytes()

Set a parameter to a Bytes array.

void setBytes(
   unsigned int paramIndex,
   const Bytes &val);

paramIndex

val

setCharacterStreamMode()

Defines that a column is to be returned as a character stream.

void setCharacterStreamMode(
   unsigned int colIndex,
   unsigned int size);

void setCharacterStreamMode(
   unsigned int colIndex,
   unsigned int size,
   bool inArg);

colIndex

size

inArg

setCharSet()

Overrides the default character set for the specified parameter. Data is assumed to be in the specified character set and is converted to database character set. For OUT binds, this specifies the character set to which database characters are converted to.

void setCharSet(
   unsigned int paramIndex,
   string charSet);

paramIndex

charSet

setClob()

Set a parameter to a Clob value.

void setClob(
   unsigned int paramIndex,
   const Clob &val);

paramIndex

val

setDate()

Set a parameter to a Date value.

void setDate(
   unsigned int paramIndex,
   const Date &val);

paramIndex

val

setDatabaseNCHARParam()

If the parameter is going to be inserted in a column that contains data in the database's NCHAR character set, then OCCI must be informed by passing a TRUE value. A FALSE can be passed to restore the dafault.Returns returns the character set that is in effect for the specified parameter.

void setDatabaseNCHARParam(
   unsigned int paramIndex,
   bool isNCHAR);

paramIndex

isNCHAR

setDataBuffer()

Specifies a data buffer where data would be available. Also, used for OUT bind parameters of callable statements (and DML returning OUT binds in future).

The buffer parameter is a pointer to a user allocated data buffer. The current length of data must be specified in the length parameter. The amount of data should not exceed the size parameter. Finally, type is the data type of the data.

Note that not all types can be supplied in the buffer. For example, all OCCI allocated types (such as Bytes, Date and so on) cannot be provided by the setDataBuffer() interface. Similarly, C++ Standard Library strings cannot be provided with the setDataBuffer()interface either. The type can be any of OCI data types such VARCHAR2, CSTRING, CHARZ and so on.

If setDataBuffer() is used to specify data for iterative or array executes, it should be called only once in the first iteration only. For subsequent iterations, OCCI would assume that data is at buffer +(i*size) location where i is the iteration number. Similarly the length of the data would be assumed to be at (length+i).

void setDataBuffer(
   unsigned int paramIndex,
   void *buffer,
   Type type,
   sb4 size,
   ub2 *length,
   sb2 *ind = NULL,
   ub2 *rc= NULL);

paramIndex

buffer

type

size

length

ind

rc

setDataBufferArray()

Specify an array of data buffers where data would be available for reading or writing. Used for IN, OUT, and IN/OUT bind parameters for stored procedures which read/write array parameters.

• A stored procedure can have an array of values for IN, IN/OUT, or OUT parameters. In this case, the parameter must be specified using the setDataBufferArray() method. The array is specified just as for the setDataBuffer() method for iterative or array executes, but the number of elements in the array is determined by *arrayLength parameter.

• For OUT and IN/OUT parameters, the maximum number of elements in the array is specified by the arraySize parameter. Note that for iterative prepared statements, the number of elements in the array is determined by the number of iterations, and for array executes the number of elements in the array is determined by the arrayLength parameter of the executeArrayUpdate() method. However, for array parameters of stored procedures, the number of elements in the array must be specified in the arrayLength parameter of the setDataBufferArray() method because each parameter may have a different size array.

• This is different from prepared statements where for iterative and array executes, the number of elements in the array for each parameter is the same and is determined by the number of iterations of the statement, but a callable statement is executed only once, and each of its parameter can be a varying length array with possibly a different length.

void setDataBufferArray(
   unsigned int paramIndex,
   void *buffer,
   Type type,
   ub4 arraySize,
   ub4 *arrayLength,
   sb4 elementSize,
   ub2 *elementLength,
   sb2 *ind = NULL,
   ub2 *rc = NULL);

paramIndex

buffer

type

arraySize

arrayLength

elementSize

elementLemgth

ind

rcs

setBDouble()

Sets an IEEE754 double as a bind value to a Statement object at the position specified by paramIndex attribute.

void setBDouble(
   unsigned int paramIndex,
   const BDouble dval) = 0;

paramIndex

dval

setBFloat()

Sets an IEEE754 float as a bind value to a Statement object at the position specified by the paramIndex attribute.

void setBFloat(
   unsigned int paramIndex,
   const BFloat fval) = 0;

paramIndex

fval

setDouble()

Sets a parameter to a C++ double value.

void setDouble(
   unsigned int paramIndex,
   double val);

paramIndex

val

setErrorOnNull()

Enables/disables exceptions for reading of NULL values on paramIndex parameter of the statement. If exceptions are enabled, calling a getxxx() on paramIndex parameter would result in an SQLException if the parameter value is NULL. This call can also be used to disable exceptions.

void setErrorOnNUll(
   unsigned int paramIndex,
   bool causeException);

paramIndex

causeException

setErrorOnTruncate()

This method enables/disables exceptions when truncation occurs.

void setErrorOnTruncate(
   unsigned int paramIndex,
   bool causeException);

paramIndex

causeException

setFloat()

Set a parameter to a C++ float value.

void setFloat(
   unsigned int paramIndex,
   float val);

paramIndex

val

setInt()

Set a parameter to a C++ int value.

void setInt(
   unsigned int paramIndex,
   int val);

paramIndex

val

setIntervalDS()

Set a parameter to a IntervalDS value.

void setIntervalDS(
   unsigned int paramIndex,
   const IntervalDS &val);

paramIndex

val

setIntervalYM()

Set a parameter to a Interval value.

void setIntervalYM(
   unsigned int paramIndex,
   const IntervalYM &val);

paramIndex

val

setMaxIterations()

Sets the maximum number of invocations that will be made for the DML statement. This must be called before any parameters are set on the prepared statement. The larger the iterations, the larger the numbers of parameters sent to the server in one round trip. However, a large number causes more memory to be reserved for all the parameters. Note that this is just the maximum limit. Actual number of iterations depends on the number of calls to addIteration().

void setMaxIterations(
   unsigned int maxIterations);

maxIterations

setMaxParamSize()

This method sets the maximum amount of data to be sent or received for the specified parameter. It only applies to character and binary data. If the maximum amount is exceeded, the excess data is discarded. This method can be very useful when working with a LONG column. It can be used to truncate the LONG column by reading or writing it into a string or Bytes data type.

If the getSQL() or setBytes() method has been called to bind a value to an IN/OUT parameter of a PL/SQL procedure, and the size of the OUT value is expected to be greater than the size of the IN value, then setMaxParamSize() should be called.

void setMaxParamSize(
   unsigned int paramIndex,
   unsigned int maxSize);

paramIndex

maxSize

setNull()

Set a parameter to SQL NULL. Note that you must specify the parameter's SQL type.

void setNull(
   unsigned int paramIndex,
   Type type);

paramIndex

type

setNumber()

Set a parameter to a Number value.

void setNumber(
   unsigned int paramIndex,
   const Number &val);

paramIndex

val

setObject()

Set the value of a parameter using an object; use the C++.lang equivalent objects for integral values. The OCCI specification specifies a standard mapping from C++ Object types to SQL types. The given parameter C++ object will be converted to the corresponding SQL type before being sent to the database.

void setObject(
   unsigned int paramIndex,
   PObject* val);

void setObject(
   unsigned int paramIndex,
   PObject* val,
   const USting &sqltyp);

paramIndex

val

sqltyp

setPrefetchMemorySize()

Set the amount of memory that will be used internally by OCCI to store data fetched during each round trip to the server. A value of 0 means that the amount of data fetched during the round trip is constrained by the FetchRowCount parameter. If both parameters are nonzero, the smaller of the two is used.

void setPrefetchMemorySize(
   unsigned int bytes);

bytes

setPrefetchRowCount()

Set the number of rows that will be fetched internally by OCCI during each round trip to the server. A value of 0 means that the amount of data fetched during the round trip is constrained by the FetchMemorySize parameter. If both parameters are nonzero, the smaller of the two is used. If both of these parameters are zero, row count internally defaults to 1 row and that is the value returned from the getFetchRowCount() method.

void setPrefetchRowCount(
   unsigned int rowCount);

rowCount

setRowid()

Set a Rowid bytes array for a bind position.

void setRowid(
   unsigned int paramIndex,
   const Bytes &val);

paramIndex

val

setSQL()

A new SQL string can be associated with a Statement object by this call. Resources associated with the previous SQL statement are freed. In particular, a previously obtained result set is invalidated. If an empty sql string, "", was used when the Statement was created, a setSQL method with the proper SQL string must be done prior to execution.

void setSQL(
   const string &sql);

sql

setSQLUString()

Associate an SQL statement with this object. Unicode support: the client Environment should be initialized in OCCIUTIF16 mode.

void setSQLUString(
   const UString &sql);

sql

setString()

Set a parameter for a specified index.

void setString(
   unsigned int paramIndex,
   const string &val);

paramIndex

val

setTimestamp()

Set a parameter to a Timestamp value.

void setTimestamp(
   unsigned int paramIndex,
   const Timestamp &val);

paramIndex

val

setUInt()

Set a parameter to a C++ unsigned int value.

void setUInt(
   unsigned int paramIndex,
   unsigned int val);

paramIndex

val

setUString()

Set a parameter for a specified index; globalization enabled.

void setUString(
   unsigned int paramIndex,
   const UString &val);

paramIndex

val

setVector()

Sets a parameter to a vector. This method should be used when the type is a collection type, varrays or nested tables. The SQL Type of the elements in the collection should be compatible with the type of the vector. For example, if the collection is a varray of VARCHAR2, use vector<string>.

void setVector(
   Statement *stmt,
   unsigned int paramIndex,
   const OCCI_STD_NAMESPACE::vector< T > &vect,
   const OCCI_STD_NAMESPACE::string &schemaName,
   const OCCI_STD_NAMESPACE::string &typeName);

void setVector(
   Statement *stmt,
   unsigned int paramIndex,
   const OCCI_STD_NAMESPACE::vector<T* > &vect,
   const OCCI_STD_NAMESPACE::string &schemaName,
   const OCCI_STD_NAMESPACE::string &typeName);

void setVector(
   Statement *stmt,
   unsigned int paramIndex,
   const std::vector<Bfile> &vect,
   const UString &sqltype;

void setVector(
   Statement *stmt,
   unsigned int paramIndex,
   const std::vector<Blob> &vect,
   const UString &sqltype;

void setVector(
   Statement *stmt,
   unsigned int paramIndex,
   const std::vector<Clob> &vect,
   const UString &sqltype;

void setVector(
   Statement *stmt,
   unsigned int paramIndex,
   const std::vector<double> &vect,
   const UString &sqltype;

void setVector(
   Statement *stmt,
   unsigned int paramIndex,
   const std::vector<float> &vect,
   const UString &sqltype;

void setVector(
   Statement *stmt,
   unsigned int paramIndex,
   const std::vector<int> &vect,
   const UString &sqltype;

void setVector(
   Statement *stmt,
   unsigned int paramIndex,
   const std::vector<IntervalDS> &vect,
   const UString &sqltype;

void setVector(
   Statement *stmt,
   unsigned int paramIndex,
   const std::vector<Number> &vect,
   const UString &sqltype;

void setVector(
   Statement *stmt,
   unsigned int paramIndex,
   const std::vector<RefAny> &vect,
   const UString &sqltype;

void setVector(
   Statement *stmt,
   unsigned int paramIndex,
   const std::vector<Timestamp> &vect,
   const UString &sqltype;

void setVector(
   Statement *stmt,
   unsigned int paramIndex,
   const std::vector<unsigned int> &vect,
   const UString &sqltype;

void setVector(
   Statement *stmt,
   unsigned int paramIndex,
   const vector<BDouble> &vect
   const string &sqltype);

void setVector(
   Statement *stmt,
   unsigned int paramIndex,
   const vector<Bfile> &vect,
   const string &schemaName,
   const string &typeName);

void setVector(
   Statement *stmt,
   unsigned int paramIndex,
   const vector<Bfile> &vect,
   const UString &schemaName,
   const UString &typeName);

void setVector(
   Statement *stmt,
   unsigned int paramIndex,
   const vector<BFloat> &vect
   const string &sqltype);

void setVector(
   Statement *stmt,
   unsigned int paramIndex,
   const vector<Blob> &vect,
   const string &schemaName,
   const string &typeName);

void setVector(
   Statement *stmt,
   unsigned int paramIndex,
   const vector<Blob> &vect,
   const UString &schemaName,
   const UString &typeName);

void setVector(
   Statement *stmt,
   unsigned int paramIndex,
   const vector<Clob> &vect,
   const string &schemaName,
   const string &typeName);

void setVector(
   Statement *stmt,
   unsigned int paramIndex,
   const vector<Clob> &vect,
   const UString &schemaName,
   const UString &typeName);

void setVector(
   Statement *stmt,
   unsigned int paramIndex,
   const vector<Date> &vect,
   const string &schemaName,
   const string &typeName);

void setVector(
   Statement *stmt,
   unsigned int paramIndex,
   const vector<Date> &vect,
   const UString &schemaName,
   const UString &typeName);

void setVector(
   Statement *stmt,
   unsigned int paramIndex,
   const vector<Date> &vect,
   const UString &sqltype;

void setVector(
   Statement *stmt,
   unsigned int paramIndex,
   const vector<double> &vect,
   const string &schemaName,
   const string &typeName);

void setVector(
   Statement *stmt,
   unsigned int paramIndex,
   const vector<double> &vect,
   const UString &schemaName,
   const UString &typeName);

void setVector(
   Statement *stmt,
   unsigned int paramIndex,
   const vector<float> &vect,
   const string &schemaName,
   const string &typeName);

void setVector(
   Statement *stmt,
   unsigned int paramIndex,
   const vector<float> &vect,
   const UString &schemaName,
   const UString &typeName);

void setVector(
   Statement *stmt,
   unsigned int paramIndex,
   const vector<int> &vect,
   const string &schemaName,
   const string &typeName);

void setVector(
   Statement *stmt,
   unsigned int paramIndex,
   const vector<int> &vect,
   const UString &schemaName,
   const UString &typeName);

void setVector(
   Statement *stmt,
   unsigned int paramIndex,
   const vector<IntervalDS> &vect,
   const string &schemaName,
   const string &typeName);

void setVector(
   Statement *stmt,
   unsigned int paramIndex,
   const vector<IntervalDS> &vect,
   const UString &schemaName,
   const UString &typeName);

void setVector(
   Statement *stmt,
   unsigned int paramIndex,
   const vector<IntervalYM> &vect,
   const string &schemaName,
   const string &typeName);

void setVector(
   Statement *stmt,
   unsigned int paramIndex,
   const vector<IntervalYM> &vect,
   const UString &schemaName,
   const UString &typeName);

void setVector(
   Statement *stmt,
   unsigned int paramIndex,
   const vector<IntervalYM> &vect,
   const UString &sqltype;

void setVector(
   Statement *stmt,
   unsigned int paramIndex,
   const vector<Number> &vect,
   const string &schemaName,
   const string &typeName);

void setVector(
   Statement *stmt,
   unsigned int paramIndex,
   const vector<Number> &vect,
   const UString &schemaName,
   const UString &typeName);

void setVector(
   Statement *stmt,
   unsigned int paramIndex,
   const vector<RefAny> &vect,
   const string &schemaName,
   const string &typeName);

void setVector(
   Statement *stmt,
   unsigned int paramIndex,
   const vector<RefAny> &vect,
   const UString &schemaName,
   const UString &typeName);

void setVector(
   Statement *stmt,
   unsigned int paramIndex,
   const vector<string> &vect,
   const string &schemaName,
   const string &typeName);

void setVector(
   Statement *stmt,
   unsigned int paramIndex,
   const vector<string> &vect,
   const UString &schemaName,
   const UString &typeName);

void setVector(
   Statement *stmt,
   unsigned int paramIndex,
   const vector<Timestamp> &vect,
   const string &schemaName,
   const string &typeName);

void setVector(
   Statement *stmt,
   unsigned int paramIndex,
   const vector<Timestamp> &vect,
   const UString &schemaName,
   const UString &typeName);

void setVector(
   Statement *stmt,
   unsigned int paramIndex,
   const vector<unsigned int> &vect,
   const string &schemaName,
   const string &typeName);

void setVector(
   Statement *stmt,
   unsigned int paramIndex,
   const vector<unsigned int> &vect,
   const UString &schemaName,
   const UString &typeName);

void setVector(
   Statement *stmt,
   unsigned int paramIndex,
   const vector<UString> &vect,
   const UString &sqltype);

void setVector(
   Statement *stmt,
   unsigned int paramIndex,
   vector<Bfile> &vect,
   string &sqltype;

void setVector(
   Statement *stmt,
   unsigned int paramIndex,
   vector<Blob> &vect,
   string &sqltype;

void setVector(
   Statement *stmt,
   unsigned int paramIndex,
   vector<Clob> &vect,
   string &sqltype;

void setVector(
   Statement *stmt,
   unsigned int paramIndex,
   vector<Date> &vect,
   string &sqltype;

void setVector(
   Statement *stmt,
   unsigned int paramIndex,
   vector<double> &vect,
   string &sqltype;

void setVector(
   Statement *stmt,
   unsigned int paramIndex,
   vector<float> &vect,
   string &sqltype;

void setVector(
   Statement *stmt,
   unsigned int paramIndex,
   vector<int> &vect,
   string &sqltype;

void setVector(
   Statement *stmt,
   unsigned int paramIndex,
   vector<IntervalDS> &vect,
   string &sqltype;

void setVector(
   Statement *stmt,
   unsigned int paramIndex,
   vector<IntervalYM> &vect,
   string &sqltype;

void setVector(
   Statement *stmt,
   unsigned int paramIndex,
   vector<Number> &vect,
   string &sqltype;

void setVector(
   Statement *stmt,
   unsigned int paramIndex,
   vector<RefAny> &vect,
   string &sqltype;

void setVector(
   Statement *stmt,
   unsigned int paramIndex,
   vector<string> &vect,
   string &sqltype;

void setVector(
   Statement *stmt,
   unsigned int paramIndex,
   vector<Timestamp> &vect,
   string &sqltype;

void setVector(
   Statement *stmt,
   unsigned int paramIndex,
   vector<unsigned int> &vect,
   string &sqltype;

template <class T>
void setVector(
   Statement *stmt,
   unsigned int paramIndex,
   const vector< T* > &vect,
   const string &sqltype);

template <class T>
void setVector(
   Statement *stmt,
   unsigned int paramIndex,
   const vector< T* > &vect,
   const UString &sqltype);

template <class T>
void setVector(
   Statement *stmt,
   unsigned int paramIndex,
   const vector<Ref<T>> &vect,
   const UString &sqltype);

template <class T>
void setVector(
   Statement *stmt,
   unsigned int paramIndex,
   const vector<T> &vect,
   const string &sqltype);

template <class T>
void setVector(
   Statement *stmt,
   unsigned int paramIndex,
   vector<Ref<T>> &vect,
   string &sqltype);

stmt

paramIndex

vect

sqltype

schemaName

typeName

setVectorOfRefs()

Sets a parameter to a vector; should be used when the type is a collection of REFs are varrays or nested tables of REFs.

template  <class T> void setVectorOfRefs(
   Statement *stmt, unsigned int paramIndex,
   const vector<Ref<T> > &vect,
   const string &sqltype) ;

template  <class T>  void setVectorOfRefs(
   Statement *stmt,
   unsigned int paramIndex,
   const vector<Ref<T> > &vect,
   const string &sqltype) ;

template  <class T> void setVectorOfRefs(
   Statement *stmt,
   unsigned int paramIndex,
   const vector<Ref<T>> &vect,
   const string &schemaName,
   const string &typeName);

template  <class T> void setVectorOfRefs(
   Statement *stmt,
   unsigned int paramIndex,
   const vector<Ref<T> &vect,
   const UString &schemaName,
   const UString &typeName);

template <class T>  void setVector(
Statement *stmt,
unsigned int paramIndex,
const OCCI_STD_NAMESPACE::vector<T* > &vect,
const UString &schemaName,
const UString &typeName) ;

stmt

paramIndex

vect

sqltype

schemaName

typeName

status()

Returns the current status of the statement. Useful when there is streamed data to be written (or read). Other methods such as getCurrentStreamParam() and getCurrentIteration() can be called to find out the streamed parameter that needs to be written and the current iteration number for an iterative or array execute. The status() method can be called repeatedly to find out the status of the execution.

The returned value is one of the following, and are defined as constants of the Statement class in Table 10-37: PREPARED, UNPREPARED, RESULT_SET_AVAILABLE, UPDATE_COUNT_AVAILABLE, NEEDS_STREAM_DATA, and STREAM_DATA_AVAILABLE

Status status() const;