Object used for executing SQL or PL/SQL statement and returning the produced results. More...

#include <ocilib.hpp>

Inherits ocilib::HandleHolder< OCI_Statement * >.

Public Types
enum	StatementTypeValues { TypeSelect = OCI_CST_SELECT, TypeUpdate = OCI_CST_UPDATE, TypeDelete = OCI_CST_DELETE, TypeInsert = OCI_CST_INSERT, TypeCreate = OCI_CST_CREATE, TypeDrop = OCI_CST_DROP, TypeAlter = OCI_CST_ALTER, TypeBegin = OCI_CST_BEGIN, TypeDeclare = OCI_CST_DECLARE, TypeCall = OCI_CST_CALL }
	Statement Type enumerated values. More...

enum	FetchModeValues { FetchForward = OCI_SFM_DEFAULT, FetchScrollable = OCI_SFM_SCROLLABLE }
	Fetch Modes enumerated values. More...

enum	BindModeValues { BindByPosition = OCI_BIND_BY_POS, BindByName = OCI_BIND_BY_NAME }
	Bind Modes enumerated values. More...

enum	LongModeValues { LongExplicit = OCI_LONG_EXPLICIT, LongImplicit = OCI_LONG_IMPLICIT }
	LONG datatype mapping modes enumerated values. More...

typedef Enum< StatementTypeValues >	StatementType
	Statement Type. More...

typedef Enum< FetchModeValues >	FetchMode
	Fetch Modes. More...

typedef Enum< BindModeValues >	BindMode
	Bind Modes. More...

typedef Enum< LongModeValues >	LongMode
	LONG datatype mapping modes. More...

Public Member Functions
	Statement (const Connection &connection)
	Parametrized constructor. More...

	~Statement ()
	Destructor.

Connection	GetConnection () const
	Return the connection associated with a statement.

void	Describe (const ostring &sql)
	Describe the select list of a SQL select statement. More...

void	Parse (const ostring &sql)
	Parse a SQL statement or PL/SQL block. More...

void	Prepare (const ostring &sql)
	Prepare a SQL statement or PL/SQL block. More...

void	Execute ()
	Execute a prepared SQL statement or PL/SQL block.

void	Execute (const ostring &sql)
	Prepare and execute a SQL statement or PL/SQL block. More...

unsigned int	GetAffectedRows () const
	Return the number of rows affected by the SQL statement. More...

ostring	GetSql () const
	Return the last SQL or PL/SQL statement prepared or executed by the statement.

Resultset	GetResultset ()
	Retrieve the resultset from an executed statement. More...

Resultset	GetNextResultset ()
	Retrieve the next available resultset. More...

void	SetBindArraySize (unsigned int size)
	Set the input array size for bulk operations. More...

unsigned int	GetBindArraySize () const
	Return the current input array size for bulk operations.

void	AllowRebinding (bool value)
	Allow different host variables to be binded using the same bind name or position between executions of a prepared statement. More...

bool	IsRebindingAllowed () const
	Indicate if rebinding is allowed on the statement. More...

unsigned int	GetBindIndex (const ostring &name) const
	Return the index of the bind from its name belonging to the statement. More...

unsigned int	GetBindCount () const
	Return the number of binds currently associated to a statement.

BindInfo	GetBind (unsigned int index) const
	Return the bind at the given index in the internal array of bind objects. More...

BindInfo	GetBind (const ostring &name) const
	Return a bind handle from its name. More...

template<class TDataType >
void	Bind (const ostring &name, TDataType &value, BindInfo::BindDirection mode)
	Bind an host variable. More...

template<class TDataType , class TExtraInfo >
void	Bind (const ostring &name, TDataType &value, TExtraInfo extraInfo, BindInfo::BindDirection mode)
	Bind an host variable with more information. More...

template<class TDataType >
void	Bind (const ostring &name, std::vector< TDataType > &values, BindInfo::BindDirection mode)
	Bind a vector of host variables. More...

template<class TDataType >
void	Bind (const ostring &name, std::vector< TDataType > &values, TypeInfo &typeInfo, BindInfo::BindDirection mode)
	Bind a vector of host variables with Oracle type information. More...

template<class TDataType , class TExtraInfo >
void	Bind (const ostring &name, std::vector< TDataType > &values, TExtraInfo extraInfo, BindInfo::BindDirection mode)
	Bind a vector of host variables with more information. More...

template<class TDataType >
void	Register (const ostring &name)
	Register a host variable as an output for a column present in a SQL RETURNING INTO clause. More...

template<class TDataType , class TExtraInfo >
void	Register (const ostring &name, TExtraInfo &extraInfo)
	Register a host variable with Oracle type information as an output for a column present in a SQL RETURNING INTO clause. More...

template<class TDataType , class TExtraInfo >
void	Register (const ostring &name, TExtraInfo extraInfo)
	Register a host variable with more information as an output for a column present in a SQL RETURNING INTO clause. More...

StatementType	GetStatementType () const
	Return the type of a SQL statement.

unsigned int	GetSqlErrorPos () const
	Return the error position (in terms of characters) in the SQL statement where the error occurred in case of SQL parsing error. More...

void	SetFetchMode (FetchMode value)
	Set the fetch mode of a SQL statement. More...

FetchMode	GetFetchMode () const
	Return the fetch mode of a SQL statement. More...

void	SetBindMode (BindMode value)
	Set the binding mode of a SQL statement. More...

BindMode	GetBindMode () const
	Return the binding mode of a SQL statement. More...

void	SetFetchSize (unsigned int value)
	Set the number of rows fetched per internal server fetch call. More...

unsigned int	GetFetchSize () const
	Return the number of rows fetched per internal server fetch call. More...

void	SetPrefetchSize (unsigned int value)
	Set the number of rows pre-fetched by OCI Client. More...

unsigned int	GetPrefetchSize () const
	Return the number of rows pre-fetched by OCI Client. More...

void	SetPrefetchMemory (unsigned int value)
	Set the amount of memory pre-fetched by OCI Client. More...

unsigned int	GetPrefetchMemory () const
	Return the amount of memory used to retrieve rows pre-fetched by OCI Client. More...

void	SetLongMaxSize (unsigned int value)
	Set the LONG datatype piece buffer size. More...

unsigned int	GetLongMaxSize () const
	Return the LONG datatype piece buffer size. More...

void	SetLongMode (LongMode value)
	Set the long datatype handling mode of a SQL statement. More...

LongMode	GetLongMode () const
	Return the long datatype handling mode of a SQL statement.

unsigned int	GetSQLCommand () const
	Return the Oracle SQL code the command held by the statement. More...

ostring	GetSQLVerb () const
	Return the verb of the SQL command held by the statement. More...

void	GetBatchErrors (std::vector< Exception > &exceptions)
	Returns all errors that occurred within a DML array statement execution.

Detailed Description

Object used for executing SQL or PL/SQL statement and returning the produced results.

This class wraps the OCILIB object handle OCI_Statement and its related methods

Definition at line 4907 of file ocilib.hpp.

Member Typedef Documentation

typedef Enum<StatementTypeValues> ocilib::Statement::StatementType

Statement Type.

Possible values are Statement::StatementTypeValues

Definition at line 4954 of file ocilib.hpp.

typedef Enum<FetchModeValues> ocilib::Statement::FetchMode

Fetch Modes.

Possible values are Statement::FetchModeValues

Definition at line 4976 of file ocilib.hpp.

typedef Enum<BindModeValues> ocilib::Statement::BindMode

Bind Modes.

Possible values are Statement::BindModeValues

Definition at line 4998 of file ocilib.hpp.

typedef Enum<LongModeValues> ocilib::Statement::LongMode

LONG datatype mapping modes.

Possible values are Statement::LongModeValues

Definition at line 5020 of file ocilib.hpp.

Member Enumeration Documentation

enum ocilib::Statement::StatementTypeValues

Statement Type enumerated values.

Enumerator
TypeSelect	SELECT statement
TypeUpdate	UPDATE statement
TypeDelete	DELETE statement
TypeInsert	INSERT statement
TypeCreate	CREATE statement
TypeDrop	DROP statement
TypeAlter	ALTER statement
TypeBegin	BEGIN statement
TypeDeclare	DECLARE statement
TypeCall	CALL statement

Definition at line 4923 of file ocilib.hpp.

enum ocilib::Statement::FetchModeValues

Fetch Modes enumerated values.

Enumerator
FetchForward	Statement is forward only
FetchScrollable	Statement is scrollable

Definition at line 4961 of file ocilib.hpp.

enum ocilib::Statement::BindModeValues

Bind Modes enumerated values.

Enumerator
BindByPosition	Bind variables are binded by name
BindByName	Bind variables are binded by position

Definition at line 4983 of file ocilib.hpp.

enum ocilib::Statement::LongModeValues

LONG datatype mapping modes enumerated values.

Enumerator
LongExplicit	LONG and LONG RAW are mapped to Long objects
LongImplicit	LONG and LONG RAW are mapped to ostring objects

Definition at line 5005 of file ocilib.hpp.

Constructor & Destructor Documentation

ocilib::Statement::Statement ( const Connection & connection )

inline

Parametrized constructor.

Parameters

connection - Parent connection

Note

The statement object must not be accessed anymore once the parent connection object gets out of scope

Definition at line 4006 of file ocilib_impl.hpp.

References ocilib::Check(), OCI_StatementCreate(), and OCI_StatementFree().

Member Function Documentation

void ocilib::Statement::Describe ( const ostring & sql )

inline

Describe the select list of a SQL select statement.

Parameters

sql	- SELECT sql statement

Note: This call sends the SELECT SQL order to the server for retrieving the description of the select order only. The command is not executed. This call is only useful to retreive information on the associated resultet Call GetResultet() after Describe() to access to SELECT list information; This call prepares the statement (internal call to Prepare()) and ask the Oracle server to describe the output SELECT list. Execute() can be called after Desbribe() in order to execute the statement, which means that the server will parse, and describe again the SQL order.

Warning: Do not use Desbribe() unless you're only interested in the resultset information because the statement will be parsed again when executed and thus leading to unnecessary server roundtrips and less performance

Definition at line 4031 of file ocilib_impl.hpp.

References ocilib::Check(), and OCI_Describe().

void ocilib::Statement::Parse ( const ostring & sql )

inline

Parse a SQL statement or PL/SQL block.

Parameters

sql	- SQL order - PL/SQL block

Note: This call sends the SQL or PL/SQL command to the server for parsing only. The command is not executed. This call is only useful to check is a command is valid or not.; This call prepares the statement (internal call to Prepare()) and ask the Oracle server to parse its SQL or PL/SQL command. Execute() can be call after Parse() in order to execute the statement, which means that the server will reparse again the command.

Warning: Do not use Parse() unless you're only interested in the parsing result because the statement will be parsed again when executed and thus leading to unnecessary server roundtrips and less performance

Definition at line 4038 of file ocilib_impl.hpp.

References ocilib::Check(), and OCI_Parse().

void ocilib::Statement::Prepare ( const ostring & sql )

inline

Prepare a SQL statement or PL/SQL block.

Parameters

sql	- SQL order or PL/SQL block

Note: With version 1.3.0 and above, do not call this function for fetched statements (REF cursors)

Definition at line 4045 of file ocilib_impl.hpp.

References ocilib::Check(), and OCI_Prepare().

void ocilib::Statement::Execute ( const ostring & sql )

inline

Prepare and execute a SQL statement or PL/SQL block.

Parameters

sql	- SQL order - PL/SQL block

Definition at line 4060 of file ocilib_impl.hpp.

References ocilib::Check(), and OCI_ExecuteStmt().

unsigned int ocilib::Statement::GetAffectedRows ( ) const

inline

Return the number of rows affected by the SQL statement.

The returned value is :

For UPDATEs : number of rows updated
For INSERTs : number of rows inserted
For DELETEs : number of rows deleted

Note: For SELECTs statements, use GetRowCount() instead

Definition at line 4067 of file ocilib_impl.hpp.

References ocilib::Check(), and OCI_GetAffectedRows().

Resultset ocilib::Statement::GetResultset ( )

inline

Retrieve the resultset from an executed statement.

Note: See Fetching data for more details about what statements can return resultsets

Warning: If the statement has not been prepared and executed, null resultset object will be returned

Definition at line 4077 of file ocilib_impl.hpp.

References ocilib::Check(), and OCI_GetResultset().

Resultset ocilib::Statement::GetNextResultset ( )

inline

Retrieve the next available resultset.

Note

it is only valid for the following statements:

Statements executing SQL UPDATE/DELETE using a RETURNING INTO clause
Statements implicitly returned from PL/SQL procedure or blocks (new feature in Oracle 12cR1) using DBMS_SQL.RETURN_RESULT()

SQL statements with a 'returning' clause can return multiple resultsets. When arrays of program variables are binded to the statement, Oracle will execute the statement for every row (iteration). Each iteration generates a resultset that can be fetched like regular ones.

Starting withOracle 12cR1, PL/SQ procedure and blocks ca return return multiple implicit resultsets Refer to Oracle documentation for more informationb.

Definition at line 4082 of file ocilib_impl.hpp.

References ocilib::Check(), and OCI_GetNextResultset().

void ocilib::Statement::SetBindArraySize ( unsigned int size )

inline

Set the input array size for bulk operations.

Parameters

size	- Array size

Warning: Do not use SetBindArraySize() for PL/SQL tables binding

Note: SetBindArraySize() is used to set the size of input bind array when using arrays for DML statements. SetBindArraySize() MUST be called to set the maximum size of the arrays to bind to the statement before any of its execution. This initial call must be bone AFTER OPrepare() and BEFORE any Bind() call taking vectors as parameter.; SetBindArraySize() can optionally be called before any later Execute() call in order to notify the statement of the exact number of elements populating the input arrays for the next execution. The array size passed to later SetBindArraySize() calls cannot be greater than the initial size otherwise an exception will be thrown.

Definition at line 4087 of file ocilib_impl.hpp.

References ocilib::Check(), and OCI_BindArraySetSize().

void ocilib::Statement::AllowRebinding ( bool value )

inline

Allow different host variables to be binded using the same bind name or position between executions of a prepared statement.

Parameters

value - Rebinding mode allowed

Note: Default value is false

Warning: When using rebinding feature, host variable rebinded to a previously allocated bind MUST be of the same datatype !

Definition at line 4097 of file ocilib_impl.hpp.

References ocilib::Check(), and OCI_AllowRebinding().

bool ocilib::Statement::IsRebindingAllowed ( ) const

inline

Indicate if rebinding is allowed on the statement.

Note: See AllowRebinding() for more details

Definition at line 4102 of file ocilib_impl.hpp.

References ocilib::Check(), and OCI_IsRebindingAllowed().

unsigned int ocilib::Statement::GetBindIndex ( const ostring & name ) const

inline

Return the index of the bind from its name belonging to the statement.

Parameters

name	- Bind variable name

Warning: The bind name is case insensitive

Note: Bind indexes start with 1 in OCILIB

Returns: Bind index on success or zero if the bind does not exists

Definition at line 4107 of file ocilib_impl.hpp.

References ocilib::Check(), and OCI_GetBindIndex().

BindInfo ocilib::Statement::GetBind ( unsigned int index ) const

inline

Return the bind at the given index in the internal array of bind objects.

Parameters

index - Bind position

Warning: Index starts at 1.

Note: Bind handle are created sequentially. For example, the third call to a Bind() call generates a bind object of index 3.

Definition at line 4117 of file ocilib_impl.hpp.

References ocilib::Check(), and OCI_GetBind().

BindInfo ocilib::Statement::GetBind ( const ostring & name ) const

inline

Return a bind handle from its name.

Parameters

name	- Bind variable name

Note: Bind names must include a semicolon at the beginning.

Definition at line 4122 of file ocilib_impl.hpp.

References ocilib::Check(), and OCI_GetBind2().

template<class TDataType >

void ocilib::Statement::Bind	(	const ostring &	name,
		TDataType &	value,
		BindInfo::BindDirection	mode
	)

inline

Bind an host variable.

Template Parameters

TDataType - C++ type of the host variable

Parameters

name	- Bind name
value	- Host variable
mode	- bind direction mode

Warning: This method has builtin specialized versions for all supported types except ostring, Clong and Blong variables. For binding ostring, Clong and Blong variables, use the version with an extra parameter.

Note: It is not necessary to specify the template datatype in the bind call as all possible specializations can be resolved automatically from the arguments.

Definition at line 4440 of file ocilib_impl.hpp.

References OCI_BindColl().

template<class TDataType , class TExtraInfo >

void ocilib::Statement::Bind	(	const ostring &	name,
		TDataType &	value,
		TExtraInfo	extraInfo,
		BindInfo::BindDirection	mode
	)

Bind an host variable with more information.

Template Parameters

TDataType	- C++ type of the host variable
TExtraInfo	- C++ type if the extra information needed for the bind call

Parameters

name	- Bind name
value	- Host variable
extraInfo	- Extra information needed for the bind call
mode	- bind direction mode

Warning: This method has builtin specialized versions for ostring, Clong and Blong variables. Pass the maximum length/size of the variable in the parameter extraInfo

Note: It is not necessary to specify the template datatype in the bind call as all possible specializations can be resolved automatically from the arguments.

template<class TDataType >

void ocilib::Statement::Bind	(	const ostring &	name,
		std::vector< TDataType > &	values,
		BindInfo::BindDirection	mode
	)

Bind a vector of host variables.

Template Parameters

TDataType - C++ type of the host variable

Parameters

name	- Bind name
values	- Vector of host variables
mode	- bind direction mode

Warning: This method has builtin specialized versions for all C++ native scalar types, Datetime and Statement objects. For others types (ostring, Clong, Blong, Raw, Object, Reference, Collection, Timestamp, Interval), use versions with extra parameters.

Note: It is not necessary to specify the template datatype in the bind call as all possible specializations can be resolved automatically from the arguments.

template<class TDataType >

void ocilib::Statement::Bind	(	const ostring &	name,
		std::vector< TDataType > &	values,
		TypeInfo &	typeInfo,
		BindInfo::BindDirection	mode
	)

Bind a vector of host variables with Oracle type information.

Template Parameters

TDataType - C++ type of the host variable

Parameters

name	- Bind name
values	- Vector of host variables
typeInfo	- Object type information
mode	- bind direction mode

Warning: This method has builtin specialized versions for Object, Reference, Collection.

Note: It is not necessary to specify the template datatype in the bind call as all possible specializations can be resolved automatically from the arguments.

Definition at line 4552 of file ocilib_impl.hpp.

References OCI_BindArrayOfColls().

template<class TDataType , class TExtraInfo >

void ocilib::Statement::Bind	(	const ostring &	name,
		std::vector< TDataType > &	values,
		TExtraInfo	extraInfo,
		BindInfo::BindDirection	mode
	)

Bind a vector of host variables with more information.

Template Parameters

TDataType	- C++ type of the host variable
TExtraInfo	- C++ type if the extra information needed for the bind call

Parameters

name	- Bind name
values	- Vector of host variables
extraInfo	- Extra information needed for the bind call
mode	- bind direction mode

Warning

This method has builtin specialized versions for ostring, Raw , Clong, Blong, Timestamp, Interval variables.

For ostring, Clong, Blong, Raw : Pass the maximum length/size of variables in the parameter extraInfo
For Timestamp, Interval : Pass a value of the matching C++ class GetType() property type OR the underlying enumeration type.

Note: It is not necessary to specify the template datatype in the bind call as all possible specializations can be resolved automatically from the arguments.

template<class TDataType >

void ocilib::Statement::Register ( const ostring & name )

Register a host variable as an output for a column present in a SQL RETURNING INTO clause.

Template Parameters

TDataType - C++ type of the host variable

Parameters

name	- Bind name

Warning

This method has builtin specialized versions for all supported types except:

Timestamp and Interval, Object and Reference : use the version that takes a TypeInfo parameter
ostring and Raw : use the version that takes an extraInfo parameter

Note: Statement, Blong and Clong are not supported for register calls

Warning: It is necessary to specify the template datatype in the register call

template<class TDataType , class TExtraInfo >

void ocilib::Statement::Register	(	const ostring &	name,
		TExtraInfo &	extraInfo
	)

Register a host variable with Oracle type information as an output for a column present in a SQL RETURNING INTO clause.

Template Parameters

TDataType	- C++ type of the host variable
TExtraInfo	- C++ type if the extra information needed for the bind call

Parameters

name	- Bind name
extraInfo	- Extra information needed for the bind call

Warning: This method has builtin specialized versions for Object and Reference.; It is necessary to specify the template datatype in the register call

template<class TDataType , class TExtraInfo >

void ocilib::Statement::Register	(	const ostring &	name,
		TExtraInfo	extraInfo
	)

Register a host variable with more information as an output for a column present in a SQL RETURNING INTO clause.

Template Parameters

TDataType	- C++ type of the host variable
TExtraInfo	- C++ type if the extra information needed for the bind call

Parameters

name	- Bind name
extraInfo	- Extra information needed for the bind call

Warning: This method has builtin specialized versions for ostring and Raw variables. Pass the maximum length/size of variables in the parameter extraInfo

Note: It is necessary to specify the template datatype in the register call

unsigned int ocilib::Statement::GetSqlErrorPos ( ) const

inline

Return the error position (in terms of characters) in the SQL statement where the error occurred in case of SQL parsing error.

Note: Positions start at 1.

Definition at line 4701 of file ocilib_impl.hpp.

References ocilib::Check(), and OCI_GetSqlErrorPos().

void ocilib::Statement::SetFetchMode ( FetchMode value )

inline

Set the fetch mode of a SQL statement.

Parameters

value - fetch mode value

Warning: SetFetchMode() MUST be called before any Execute() call

Definition at line 4706 of file ocilib_impl.hpp.

References ocilib::Check(), and OCI_SetFetchMode().

Statement::FetchMode ocilib::Statement::GetFetchMode ( ) const

inline

Return the fetch mode of a SQL statement.

Note: Default value is Statment::FetchForward

Definition at line 4711 of file ocilib_impl.hpp.

References ocilib::Check(), and OCI_GetFetchMode().

void ocilib::Statement::SetBindMode ( BindMode value )

inline

Set the binding mode of a SQL statement.

Parameters

value - binding mode value

Definition at line 4716 of file ocilib_impl.hpp.

References ocilib::Check(), and OCI_SetBindMode().

Statement::BindMode ocilib::Statement::GetBindMode ( ) const

inline

Return the binding mode of a SQL statement.

Note: Default value is Statment::BindByName

Definition at line 4721 of file ocilib_impl.hpp.

References ocilib::Check(), and OCI_GetBindMode().

void ocilib::Statement::SetFetchSize ( unsigned int value )

inline

Set the number of rows fetched per internal server fetch call.

Parameters

value - number of rows to fetch

Definition at line 4726 of file ocilib_impl.hpp.

References ocilib::Check(), and OCI_SetFetchSize().

unsigned int ocilib::Statement::GetFetchSize ( ) const

inline

Return the number of rows fetched per internal server fetch call.

Note: Default value is set to constant OCI_FETCH_SIZE

Definition at line 4731 of file ocilib_impl.hpp.

References ocilib::Check(), and OCI_GetFetchSize().

void ocilib::Statement::SetPrefetchSize ( unsigned int value )

inline

Set the number of rows pre-fetched by OCI Client.

Parameters

value - number of rows to pre-fetch

Note: To turn off pre-fetching, set both attributes (size and memory) to 0.

Definition at line 4736 of file ocilib_impl.hpp.

References ocilib::Check(), and OCI_SetPrefetchSize().

unsigned int ocilib::Statement::GetPrefetchSize ( ) const

inline

Return the number of rows pre-fetched by OCI Client.

Note: Default value is set to constant OCI_PREFETCH_SIZE

Definition at line 4741 of file ocilib_impl.hpp.

References ocilib::Check(), and OCI_GetPrefetchSize().

void ocilib::Statement::SetPrefetchMemory ( unsigned int value )

inline

Set the amount of memory pre-fetched by OCI Client.

Parameters

value - amount of memory to fetch

Note: Default value is 0 and the pre-fetch size attribute is used instead. When both attributes are set (pre-fetch size and memory) and pre-fetch memory value can hold more rows than specified by pre-fetch size, OCI uses pre-fetch size instead.; OCILIB set pre-fetch attribute to OCI_PREFETCH_SIZE when a statement is created. To setup a big value for SetPrefetchMemory(), you must call SetPrefetchSize() to 0 to make OCI consider this attribute.

Definition at line 4746 of file ocilib_impl.hpp.

References ocilib::Check(), and OCI_SetPrefetchMemory().

unsigned int ocilib::Statement::GetPrefetchMemory ( ) const

inline

Return the amount of memory used to retrieve rows pre-fetched by OCI Client.

Note: Default value is 0

Definition at line 4751 of file ocilib_impl.hpp.

References ocilib::Check(), and OCI_GetPrefetchMemory().

void ocilib::Statement::SetLongMaxSize ( unsigned int value )

inline

Set the LONG datatype piece buffer size.

Parameters

value - maximum size for long buffer

Definition at line 4756 of file ocilib_impl.hpp.

References ocilib::Check(), and OCI_SetLongMaxSize().

unsigned int ocilib::Statement::GetLongMaxSize ( ) const

inline

Return the LONG datatype piece buffer size.

Note: Default value is set to constant OCI_SIZE_LONG

Definition at line 4761 of file ocilib_impl.hpp.

References ocilib::Check(), and OCI_GetLongMaxSize().

void ocilib::Statement::SetLongMode ( LongMode value )

inline

Set the long datatype handling mode of a SQL statement.

Parameters

value - long mode value

Note: LONG RAWs can't be handled with Statement::LongImplicit mode

Definition at line 4766 of file ocilib_impl.hpp.

References ocilib::Check(), and OCI_SetLongMode().

unsigned int ocilib::Statement::GetSQLCommand ( ) const

inline

Return the Oracle SQL code the command held by the statement.

Warning: GetSQLCommand() must be called after the statement has be executed because that's the server engine that computes the SQL command code

Note: The SQL command list is available in Oracle documentations and guides

Definition at line 4776 of file ocilib_impl.hpp.

References ocilib::Check(), and OCI_GetSQLCommand().

ostring ocilib::Statement::GetSQLVerb ( ) const

inline

Return the verb of the SQL command held by the statement.

Warning: GetSQLVerb() must be called after the statement has been executed because that's the server engine that computes the SQL verb

Note: The SQL verb list is available in Oracle documentations and guides

Definition at line 4781 of file ocilib_impl.hpp.

References ocilib::Check(), ocilib::MakeString(), and OCI_GetSQLVerb().

Public Types

Public Member Functions

Detailed Description

Member Typedef Documentation

Member Enumeration Documentation

Constructor & Destructor Documentation

Member Function Documentation