OCILIB (C and C++ Driver for Oracle)
4.7.5
Open source and cross platform Oracle Driver delivering efficient access to Oracle databases.
|
OcilibCApiBinding
OCILIB offers a really easy and smart mechanism to fetch data from a SQL Statement. It looks like what's found in JDBC and other object oriented databases frameworks.
ONLY the following statements can return resultsets that can be fetched by host programs:
These resultsets are encapsulated in OCILIB by OCI_Resultset objects.
Thus, after any successful call to an OCI_Executexxx() function that executed a fetchable statement or filled output bind variables, the resultset can be retrieved by calling OCI_GetResultset()
The creation of a OCI_Resultset object consists in :
OCILIB supports multi-row fetching for increasing performances. Instead of fetching data row by row from the server (that induces lots of round-trips between the client and the server), the library prefetches data chunk by chunks (default is 20 rows). So, less network traffic and better performances. These mechanisms are completely hidden from the application which fetches the resultset row by row.
Once the Resultset handle is retrieved :
Oracle 9i introduced scrollable cursors (resultsets in OCILIB) that can be fetched:
Scrollable statements uses more server and client resources and should only be used when necessary.
Resultsets are 'forward only' by default. Call OCI_SetFetchMode() with OCI_SFM_SCROLLABLE to enable scrollable resultsets for a given statement.
The properties (columns names, types ...) of the resultset are accessible through a set of APIs.
OCI_GetString() performs an implicit conversion from ANY Oracle types:
It is possible to fetch a complete row into a user defined structure. Each column of the resultset is mapped to a structure member. The mapping rules are :
See OCI_GetStruct() and OCI_SetStructNumericType() for more details
Functions | |
OCI_SYM_PUBLIC OCI_Resultset *OCI_API | OCI_GetResultset (OCI_Statement *stmt) |
Retrieve the resultset handle from an executed statement. | |
OCI_SYM_PUBLIC boolean OCI_API | OCI_ReleaseResultsets (OCI_Statement *stmt) |
Free the statement resultsets. | |
OCI_SYM_PUBLIC boolean OCI_API | OCI_FetchNext (OCI_Resultset *rs) |
Fetch the next row of the resultset. | |
OCI_SYM_PUBLIC boolean OCI_API | OCI_FetchPrev (OCI_Resultset *rs) |
Fetch the previous row of the resultset. | |
OCI_SYM_PUBLIC boolean OCI_API | OCI_FetchFirst (OCI_Resultset *rs) |
Fetch the first row of the resultset. | |
OCI_SYM_PUBLIC boolean OCI_API | OCI_FetchLast (OCI_Resultset *rs) |
Fetch the last row of the resultset. | |
OCI_SYM_PUBLIC boolean OCI_API | OCI_FetchSeek (OCI_Resultset *rs, unsigned int mode, int offset) |
Custom Fetch of the resultset. | |
OCI_SYM_PUBLIC unsigned int OCI_API | OCI_GetRowCount (OCI_Resultset *rs) |
Retrieve the number of rows fetched so far. | |
OCI_SYM_PUBLIC unsigned int OCI_API | OCI_GetCurrentRow (OCI_Resultset *rs) |
Retrieve the current row number. | |
OCI_SYM_PUBLIC unsigned int OCI_API | OCI_GetColumnCount (OCI_Resultset *rs) |
Return the number of columns in the resultset. | |
OCI_SYM_PUBLIC OCI_Column *OCI_API | OCI_GetColumn (OCI_Resultset *rs, unsigned int index) |
Return the column object handle at the given index in the resultset. | |
OCI_SYM_PUBLIC OCI_Column *OCI_API | OCI_GetColumn2 (OCI_Resultset *rs, const otext *name) |
Return the column object handle from its name in the resultset. | |
OCI_SYM_PUBLIC unsigned int OCI_API | OCI_GetColumnIndex (OCI_Resultset *rs, const otext *name) |
Return the index of the column in the result from its name. | |
OCI_SYM_PUBLIC const otext *OCI_API | OCI_ColumnGetName (OCI_Column *col) |
Return the name of the given column. | |
OCI_SYM_PUBLIC unsigned int OCI_API | OCI_ColumnGetType (OCI_Column *col) |
Return the type of the given column. | |
OCI_SYM_PUBLIC unsigned int OCI_API | OCI_ColumnGetCharsetForm (OCI_Column *col) |
Return the charset form of the given column. | |
OCI_SYM_PUBLIC const otext *OCI_API | OCI_ColumnGetSQLType (OCI_Column *col) |
Return the Oracle SQL type name of the column data type. | |
OCI_SYM_PUBLIC unsigned int OCI_API | OCI_ColumnGetFullSQLType (OCI_Column *col, otext *buffer, unsigned int len) |
Return the Oracle SQL Full name including precision and size of the column data type. | |
OCI_SYM_PUBLIC unsigned int OCI_API | OCI_ColumnGetSize (OCI_Column *col) |
Return the size of the column. | |
OCI_SYM_PUBLIC int OCI_API | OCI_ColumnGetScale (OCI_Column *col) |
Return the scale of the column for numeric columns. | |
OCI_SYM_PUBLIC int OCI_API | OCI_ColumnGetPrecision (OCI_Column *col) |
Return the precision of the column for numeric columns. | |
OCI_SYM_PUBLIC int OCI_API | OCI_ColumnGetFractionalPrecision (OCI_Column *col) |
Return the fractional precision of the column for timestamp and interval columns. | |
OCI_SYM_PUBLIC int OCI_API | OCI_ColumnGetLeadingPrecision (OCI_Column *col) |
Return the leading precision of the column for interval columns. | |
OCI_SYM_PUBLIC boolean OCI_API | OCI_ColumnGetNullable (OCI_Column *col) |
Return the nullable attribute of the column. | |
OCI_SYM_PUBLIC boolean OCI_API | OCI_ColumnGetCharUsed (OCI_Column *col) |
Return TRUE if the length of the column is character-length or FALSE if it is byte-length. | |
OCI_SYM_PUBLIC unsigned int OCI_API | OCI_ColumnGetPropertyFlags (OCI_Column *col) |
Return the column property flags. | |
OCI_SYM_PUBLIC unsigned int OCI_API | OCI_ColumnGetCollationID (OCI_Column *col) |
Return the column collation ID. | |
OCI_SYM_PUBLIC OCI_TypeInfo *OCI_API | OCI_ColumnGetTypeInfo (OCI_Column *col) |
Return the type information object associated to the column. | |
OCI_SYM_PUBLIC unsigned int OCI_API | OCI_ColumnGetSubType (OCI_Column *col) |
Return the OCILIB object subtype of a column. | |
OCI_SYM_PUBLIC boolean OCI_API | OCI_SetStructNumericType (OCI_Resultset *rs, unsigned int index, unsigned int type) |
set the numeric data type of the given structure member (identified from position in the resultset) to retrieve when calling OCI_GetStruct() | |
OCI_SYM_PUBLIC boolean OCI_API | OCI_SetStructNumericType2 (OCI_Resultset *rs, const otext *name, unsigned int type) |
set the numeric data type of the given structure member (identified from column name in the resultset) to retrieve when calling OCI_GetStruct() | |
OCI_SYM_PUBLIC boolean OCI_API | OCI_GetStruct (OCI_Resultset *rs, void *row_struct, void *row_struct_ind) |
Return the row columns values into a single structure. | |
OCI_SYM_PUBLIC OCI_Number *OCI_API | OCI_GetNumber (OCI_Resultset *rs, unsigned int index) |
Return the current Number value of the column at the given index in the resultset. | |
OCI_SYM_PUBLIC OCI_Number *OCI_API | OCI_GetNumber2 (OCI_Resultset *rs, const otext *name) |
Return the current number value of the column from its name in the resultset. | |
OCI_SYM_PUBLIC short OCI_API | OCI_GetShort (OCI_Resultset *rs, unsigned int index) |
Return the current short value of the column at the given index in the resultset. | |
OCI_SYM_PUBLIC short OCI_API | OCI_GetShort2 (OCI_Resultset *rs, const otext *name) |
Return the current short value of the column from its name in the resultset. | |
OCI_SYM_PUBLIC unsigned short OCI_API | OCI_GetUnsignedShort (OCI_Resultset *rs, unsigned int index) |
Return the current unsigned short value of the column at the given index in the resultset. | |
OCI_SYM_PUBLIC unsigned short OCI_API | OCI_GetUnsignedShort2 (OCI_Resultset *rs, const otext *name) |
Return the current unsigned short value of the column from its name in the resultset. | |
OCI_SYM_PUBLIC int OCI_API | OCI_GetInt (OCI_Resultset *rs, unsigned int index) |
Return the current integer value of the column at the given index in the resultset. | |
OCI_SYM_PUBLIC int OCI_API | OCI_GetInt2 (OCI_Resultset *rs, const otext *name) |
Return the current integer value of the column from its name in the resultset. | |
OCI_SYM_PUBLIC unsigned int OCI_API | OCI_GetUnsignedInt (OCI_Resultset *rs, unsigned int index) |
Return the current unsigned integer value of the column at the given index in the resultset. | |
OCI_SYM_PUBLIC unsigned int OCI_API | OCI_GetUnsignedInt2 (OCI_Resultset *rs, const otext *name) |
Return the current unsigned integer value of the column from its name in the resultset. | |
OCI_SYM_PUBLIC big_int OCI_API | OCI_GetBigInt (OCI_Resultset *rs, unsigned int index) |
Return the current big integer value of the column at the given index in the resultset. | |
OCI_SYM_PUBLIC big_int OCI_API | OCI_GetBigInt2 (OCI_Resultset *rs, const otext *name) |
Return the current big integer value of the column from its name in the resultset. | |
OCI_SYM_PUBLIC big_uint OCI_API | OCI_GetUnsignedBigInt (OCI_Resultset *rs, unsigned int index) |
Return the current unsigned big integer value of the column at the given index in the resultset. | |
OCI_SYM_PUBLIC big_uint OCI_API | OCI_GetUnsignedBigInt2 (OCI_Resultset *rs, const otext *name) |
Return the current unsigned big integer value of the column from its name in the resultset. | |
OCI_SYM_PUBLIC const otext *OCI_API | OCI_GetString (OCI_Resultset *rs, unsigned int index) |
Return the current string value of the column at the given index in the resultset. | |
OCI_SYM_PUBLIC const otext *OCI_API | OCI_GetString2 (OCI_Resultset *rs, const otext *name) |
Return the current string value of the column from its name in the resultset. | |
OCI_SYM_PUBLIC unsigned int OCI_API | OCI_GetRaw (OCI_Resultset *rs, unsigned int index, void *buffer, unsigned int len) |
Copy the current raw value of the column at the given index into the specified buffer. | |
OCI_SYM_PUBLIC unsigned int OCI_API | OCI_GetRaw2 (OCI_Resultset *rs, const otext *name, void *buffer, unsigned int len) |
Copy the current raw value of the column from its name into the specified buffer. | |
OCI_SYM_PUBLIC double OCI_API | OCI_GetDouble (OCI_Resultset *rs, unsigned int index) |
Return the current double value of the column at the given index in the resultset. | |
OCI_SYM_PUBLIC double OCI_API | OCI_GetDouble2 (OCI_Resultset *rs, const otext *name) |
Return the current double value of the column from its name in the resultset. | |
OCI_SYM_PUBLIC float OCI_API | OCI_GetFloat (OCI_Resultset *rs, unsigned int index) |
Return the current float value of the column at the given index in the resultset. | |
OCI_SYM_PUBLIC float OCI_API | OCI_GetFloat2 (OCI_Resultset *rs, const otext *name) |
Return the current float value of the column from its name in the resultset. | |
OCI_SYM_PUBLIC OCI_Date *OCI_API | OCI_GetDate (OCI_Resultset *rs, unsigned int index) |
Return the current date value of the column at the given index in the resultset. | |
OCI_SYM_PUBLIC OCI_Date *OCI_API | OCI_GetDate2 (OCI_Resultset *rs, const otext *name) |
Return the current date value of the column from its name in the resultset. | |
OCI_SYM_PUBLIC OCI_Timestamp *OCI_API | OCI_GetTimestamp (OCI_Resultset *rs, unsigned int index) |
Return the current timestamp value of the column at the given index in the resultset. | |
OCI_SYM_PUBLIC OCI_Timestamp *OCI_API | OCI_GetTimestamp2 (OCI_Resultset *rs, const otext *name) |
Return the current timestamp value of the column from its name in the resultset. | |
OCI_SYM_PUBLIC OCI_Interval *OCI_API | OCI_GetInterval (OCI_Resultset *rs, unsigned int index) |
Return the current interval value of the column at the given index in the resultset. | |
OCI_SYM_PUBLIC OCI_Interval *OCI_API | OCI_GetInterval2 (OCI_Resultset *rs, const otext *name) |
Return the current interval value of the column from its name in the resultset. | |
OCI_SYM_PUBLIC OCI_Statement *OCI_API | OCI_GetStatement (OCI_Resultset *rs, unsigned int index) |
Return the current cursor value (Nested table) of the column at the given index in the resultset. | |
OCI_SYM_PUBLIC OCI_Statement *OCI_API | OCI_GetStatement2 (OCI_Resultset *rs, const otext *name) |
Return the current cursor value of the column from its name in the resultset. | |
OCI_SYM_PUBLIC OCI_Lob *OCI_API | OCI_GetLob (OCI_Resultset *rs, unsigned int index) |
Return the current lob value of the column at the given index in the resultset. | |
OCI_SYM_PUBLIC OCI_Lob *OCI_API | OCI_GetLob2 (OCI_Resultset *rs, const otext *name) |
Return the current lob value of the column from its name in the resultset. | |
OCI_SYM_PUBLIC OCI_File *OCI_API | OCI_GetFile (OCI_Resultset *rs, unsigned int index) |
Return the current File value of the column at the given index in the resultset. | |
OCI_SYM_PUBLIC OCI_File *OCI_API | OCI_GetFile2 (OCI_Resultset *rs, const otext *name) |
Return the current File value of the column from its name in the resultset. | |
OCI_SYM_PUBLIC OCI_Object *OCI_API | OCI_GetObject (OCI_Resultset *rs, unsigned int index) |
Return the current Object value of the column at the given index in the resultset. | |
OCI_SYM_PUBLIC OCI_Object *OCI_API | OCI_GetObject2 (OCI_Resultset *rs, const otext *name) |
Return the current Object value of the column from its name in the resultset. | |
OCI_SYM_PUBLIC OCI_Coll *OCI_API | OCI_GetColl (OCI_Resultset *rs, unsigned int index) |
Return the current Collection value of the column at the given index in the resultset. | |
OCI_SYM_PUBLIC OCI_Coll *OCI_API | OCI_GetColl2 (OCI_Resultset *rs, const otext *name) |
Return the current Collection value of the column from its name in the resultset. | |
OCI_SYM_PUBLIC OCI_Ref *OCI_API | OCI_GetRef (OCI_Resultset *rs, unsigned int index) |
Return the current Ref value of the column at the given index in the resultset. | |
OCI_SYM_PUBLIC OCI_Ref *OCI_API | OCI_GetRef2 (OCI_Resultset *rs, const otext *name) |
Return the current Ref value of the column from its name in the resultset. | |
OCI_SYM_PUBLIC OCI_Long *OCI_API | OCI_GetLong (OCI_Resultset *rs, unsigned int index) |
Return the current Long value of the column at the given index in the resultset. | |
OCI_SYM_PUBLIC OCI_Long *OCI_API | OCI_GetLong2 (OCI_Resultset *rs, const otext *name) |
Return the current Long value of the column from its name in the resultset. | |
OCI_SYM_PUBLIC boolean OCI_API | OCI_IsNull (OCI_Resultset *rs, unsigned int index) |
Check if the current row value is null for the column at the given index in the resultset. | |
OCI_SYM_PUBLIC unsigned int OCI_API | OCI_GetDataSize (OCI_Resultset *rs, unsigned int index) |
Return the size of the value of the column at the given index in the resultset. | |
OCI_SYM_PUBLIC unsigned int OCI_API | OCI_GetDataSize2 (OCI_Resultset *rs, const otext *name) |
Return the size of the value of the column from its name in the resultset. | |
OCI_SYM_PUBLIC boolean OCI_API | OCI_IsNull2 (OCI_Resultset *rs, const otext *name) |
Check if the current row value is null for the column of the given name in the resultset. | |
OCI_SYM_PUBLIC OCI_Statement *OCI_API | OCI_ResultsetGetStatement (OCI_Resultset *rs) |
Return the statement handle associated with a resultset handle. | |
OCI_SYM_PUBLIC unsigned int OCI_API | OCI_GetDataLength (OCI_Resultset *rs, unsigned int index) |
Return the current row data length of the column at the given index in the resultset. | |
OCI_SYM_PUBLIC OCI_Resultset *OCI_API OCI_GetResultset | ( | OCI_Statement * | stmt | ) |
#include <api.h>
Retrieve the resultset handle from an executed statement.
stmt | - Statement handle |
Referenced by ocilib::Statement::GetResultset().
OCI_SYM_PUBLIC boolean OCI_API OCI_ReleaseResultsets | ( | OCI_Statement * | stmt | ) |
#include <api.h>
Free the statement resultsets.
stmt | - Statement handle |
OCI_SYM_PUBLIC boolean OCI_API OCI_FetchNext | ( | OCI_Resultset * | rs | ) |
#include <api.h>
Fetch the next row of the resultset.
rs | - Resultset handle |
Referenced by ocilib::Resultset::Next().
OCI_SYM_PUBLIC boolean OCI_API OCI_FetchPrev | ( | OCI_Resultset * | rs | ) |
#include <api.h>
Fetch the previous row of the resultset.
rs | - Resultset handle |
Referenced by ocilib::Resultset::Prev().
OCI_SYM_PUBLIC boolean OCI_API OCI_FetchFirst | ( | OCI_Resultset * | rs | ) |
#include <api.h>
Fetch the first row of the resultset.
rs | - Resultset handle |
Referenced by ocilib::Resultset::First().
OCI_SYM_PUBLIC boolean OCI_API OCI_FetchLast | ( | OCI_Resultset * | rs | ) |
#include <api.h>
Fetch the last row of the resultset.
rs | - Resultset handle |
Referenced by ocilib::Resultset::Last().
OCI_SYM_PUBLIC boolean OCI_API OCI_FetchSeek | ( | OCI_Resultset * | rs, |
unsigned int | mode, | ||
int | offset | ||
) |
#include <api.h>
Custom Fetch of the resultset.
rs | - Resultset handle |
mode | - Fetch direction |
offset | - Fetch offset |
Referenced by ocilib::Resultset::Seek().
OCI_SYM_PUBLIC unsigned int OCI_API OCI_GetRowCount | ( | OCI_Resultset * | rs | ) |
#include <api.h>
Retrieve the number of rows fetched so far.
rs | - Resultset handle |
Referenced by ocilib::Resultset::GetCount().
OCI_SYM_PUBLIC unsigned int OCI_API OCI_GetCurrentRow | ( | OCI_Resultset * | rs | ) |
#include <api.h>
Retrieve the current row number.
rs | - Resultset handle |
Referenced by ocilib::Resultset::GetCurrentRow().
OCI_SYM_PUBLIC unsigned int OCI_API OCI_GetColumnCount | ( | OCI_Resultset * | rs | ) |
#include <api.h>
Return the number of columns in the resultset.
rs | - Resultset handle |
Referenced by ocilib::Resultset::GetColumnCount().
OCI_SYM_PUBLIC OCI_Column *OCI_API OCI_GetColumn | ( | OCI_Resultset * | rs, |
unsigned int | index | ||
) |
#include <api.h>
Return the column object handle at the given index in the resultset.
rs | - Resultset handle |
index | - Column position |
Referenced by ocilib::Resultset::GetColumn().
OCI_SYM_PUBLIC OCI_Column *OCI_API OCI_GetColumn2 | ( | OCI_Resultset * | rs, |
const otext * | name | ||
) |
#include <api.h>
Return the column object handle from its name in the resultset.
rs | - Resultset handle |
name | - Column name |
Referenced by ocilib::Resultset::GetColumn().
OCI_SYM_PUBLIC unsigned int OCI_API OCI_GetColumnIndex | ( | OCI_Resultset * | rs, |
const otext * | name | ||
) |
#include <api.h>
Return the index of the column in the result from its name.
rs | - Resultset handle |
name | - Column name |
Referenced by ocilib::Resultset::GetColumnIndex().
OCI_SYM_PUBLIC const otext *OCI_API OCI_ColumnGetName | ( | OCI_Column * | col | ) |
#include <api.h>
Return the name of the given column.
col | - Column handle |
Referenced by ocilib::Column::GetName().
OCI_SYM_PUBLIC unsigned int OCI_API OCI_ColumnGetType | ( | OCI_Column * | col | ) |
#include <api.h>
Return the type of the given column.
col | - Column handle |
Referenced by ocilib::Column::GetType().
OCI_SYM_PUBLIC unsigned int OCI_API OCI_ColumnGetCharsetForm | ( | OCI_Column * | col | ) |
#include <api.h>
Return the charset form of the given column.
col | - Column handle |
Referenced by ocilib::Column::GetCharsetForm().
OCI_SYM_PUBLIC const otext *OCI_API OCI_ColumnGetSQLType | ( | OCI_Column * | col | ) |
#include <api.h>
Return the Oracle SQL type name of the column data type.
col | - Column handle |
Referenced by ocilib::Column::GetSQLType().
OCI_SYM_PUBLIC unsigned int OCI_API OCI_ColumnGetFullSQLType | ( | OCI_Column * | col, |
otext * | buffer, | ||
unsigned int | len | ||
) |
#include <api.h>
Return the Oracle SQL Full name including precision and size of the column data type.
col | - Column handle |
buffer | - buffer to store the full column type name and size |
len | - max size of the buffer in characters |
Referenced by ocilib::Column::GetFullSQLType().
OCI_SYM_PUBLIC unsigned int OCI_API OCI_ColumnGetSize | ( | OCI_Column * | col | ) |
#include <api.h>
Return the size of the column.
col | - Column handle |
Referenced by ocilib::Column::GetSize().
OCI_SYM_PUBLIC int OCI_API OCI_ColumnGetScale | ( | OCI_Column * | col | ) |
#include <api.h>
Return the scale of the column for numeric columns.
col | - Column handle |
Referenced by ocilib::Column::GetScale().
OCI_SYM_PUBLIC int OCI_API OCI_ColumnGetPrecision | ( | OCI_Column * | col | ) |
#include <api.h>
Return the precision of the column for numeric columns.
col | - Column handle |
Referenced by ocilib::Column::GetPrecision().
OCI_SYM_PUBLIC int OCI_API OCI_ColumnGetFractionalPrecision | ( | OCI_Column * | col | ) |
#include <api.h>
Return the fractional precision of the column for timestamp and interval columns.
col | - Column handle |
Referenced by ocilib::Column::GetFractionalPrecision().
OCI_SYM_PUBLIC int OCI_API OCI_ColumnGetLeadingPrecision | ( | OCI_Column * | col | ) |
#include <api.h>
Return the leading precision of the column for interval columns.
col | - Column handle |
Referenced by ocilib::Column::GetLeadingPrecision().
OCI_SYM_PUBLIC boolean OCI_API OCI_ColumnGetNullable | ( | OCI_Column * | col | ) |
#include <api.h>
Return the nullable attribute of the column.
col | - Column handle |
Referenced by ocilib::Column::IsNullable().
OCI_SYM_PUBLIC boolean OCI_API OCI_ColumnGetCharUsed | ( | OCI_Column * | col | ) |
#include <api.h>
Return TRUE if the length of the column is character-length or FALSE if it is byte-length.
col | - Column handle |
Referenced by ocilib::Column::IsCharSemanticUsed().
OCI_SYM_PUBLIC unsigned int OCI_API OCI_ColumnGetPropertyFlags | ( | OCI_Column * | col | ) |
#include <api.h>
Return the column property flags.
col | - Column handle |
For flags are:
Referenced by ocilib::Column::GetPropertyFlags().
OCI_SYM_PUBLIC unsigned int OCI_API OCI_ColumnGetCollationID | ( | OCI_Column * | col | ) |
#include <api.h>
Return the column collation ID.
col | - Column handle |
Possible values:
Referenced by ocilib::Column::GetCollationID().
OCI_SYM_PUBLIC OCI_TypeInfo *OCI_API OCI_ColumnGetTypeInfo | ( | OCI_Column * | col | ) |
#include <api.h>
Return the type information object associated to the column.
col | - Column handle |
Referenced by ocilib::Column::GetTypeInfo().
OCI_SYM_PUBLIC unsigned int OCI_API OCI_ColumnGetSubType | ( | OCI_Column * | col | ) |
#include <api.h>
Return the OCILIB object subtype of a column.
col | - Column handle |
For OCI_Long type the possible values are:
For OCI_Lob type the possible values are:
For OCI_File type the possible values are:
For OCI_Timestamp type the possible values are:
For OCI_Interval type the possible values are:
For numeric columns the possible values are:
Referenced by ocilib::Column::GetSubType().
OCI_SYM_PUBLIC boolean OCI_API OCI_SetStructNumericType | ( | OCI_Resultset * | rs, |
unsigned int | index, | ||
unsigned int | type | ||
) |
#include <api.h>
set the numeric data type of the given structure member (identified from position in the resultset) to retrieve when calling OCI_GetStruct()
rs | - Resultset handle |
index | - Column position |
type | - Numeric type |
OCI_SYM_PUBLIC boolean OCI_API OCI_SetStructNumericType2 | ( | OCI_Resultset * | rs, |
const otext * | name, | ||
unsigned int | type | ||
) |
#include <api.h>
set the numeric data type of the given structure member (identified from column name in the resultset) to retrieve when calling OCI_GetStruct()
rs | - Resultset handle |
name | - Column name |
type | - Numeric type |
OCI_SYM_PUBLIC boolean OCI_API OCI_GetStruct | ( | OCI_Resultset * | rs, |
void * | row_struct, | ||
void * | row_struct_ind | ||
) |
#include <api.h>
Return the row columns values into a single structure.
rs | - Resultset handle |
row_struct | - pointer to user row structure |
row_struct_ind | - pointer to user indicator structure |
The user structure must have the same members than the resultset. Each column in the resultset must have its equivalent in the structure. Fields must be in the same order.
The mapping rules are :
The user structure pointer is not mandatory
This structure must have one boolean field per column in the resultset and respect in the same member order.
If the value of the given member is TRUE, it means the value in the user row structure is NOT NULL, otherwise its NULL
The user indicator structure pointer is mandatory
OCI_SYM_PUBLIC OCI_Number *OCI_API OCI_GetNumber | ( | OCI_Resultset * | rs, |
unsigned int | index | ||
) |
#include <api.h>
Return the current Number value of the column at the given index in the resultset.
rs | - Resultset handle |
index | - Column position |
OCI_SYM_PUBLIC OCI_Number *OCI_API OCI_GetNumber2 | ( | OCI_Resultset * | rs, |
const otext * | name | ||
) |
#include <api.h>
Return the current number value of the column from its name in the resultset.
rs | - Resultset handle |
name | - Column name |
OCI_SYM_PUBLIC short OCI_API OCI_GetShort | ( | OCI_Resultset * | rs, |
unsigned int | index | ||
) |
#include <api.h>
Return the current short value of the column at the given index in the resultset.
rs | - Resultset handle |
index | - Column position |
OCI_SYM_PUBLIC short OCI_API OCI_GetShort2 | ( | OCI_Resultset * | rs, |
const otext * | name | ||
) |
#include <api.h>
Return the current short value of the column from its name in the resultset.
rs | - Resultset handle |
name | - Column name |
OCI_SYM_PUBLIC unsigned short OCI_API OCI_GetUnsignedShort | ( | OCI_Resultset * | rs, |
unsigned int | index | ||
) |
#include <api.h>
Return the current unsigned short value of the column at the given index in the resultset.
rs | - Resultset handle |
index | - Column position |
OCI_SYM_PUBLIC unsigned short OCI_API OCI_GetUnsignedShort2 | ( | OCI_Resultset * | rs, |
const otext * | name | ||
) |
#include <api.h>
Return the current unsigned short value of the column from its name in the resultset.
rs | - Resultset handle |
name | - Column name |
OCI_SYM_PUBLIC int OCI_API OCI_GetInt | ( | OCI_Resultset * | rs, |
unsigned int | index | ||
) |
#include <api.h>
Return the current integer value of the column at the given index in the resultset.
rs | - Resultset handle |
index | - Column position |
OCI_SYM_PUBLIC int OCI_API OCI_GetInt2 | ( | OCI_Resultset * | rs, |
const otext * | name | ||
) |
#include <api.h>
Return the current integer value of the column from its name in the resultset.
rs | - Resultset handle |
name | - Column name |
OCI_SYM_PUBLIC unsigned int OCI_API OCI_GetUnsignedInt | ( | OCI_Resultset * | rs, |
unsigned int | index | ||
) |
#include <api.h>
Return the current unsigned integer value of the column at the given index in the resultset.
rs | - Resultset handle |
index | - Column position |
OCI_SYM_PUBLIC unsigned int OCI_API OCI_GetUnsignedInt2 | ( | OCI_Resultset * | rs, |
const otext * | name | ||
) |
#include <api.h>
Return the current unsigned integer value of the column from its name in the resultset.
rs | - Resultset handle |
name | - Column name |
OCI_SYM_PUBLIC big_int OCI_API OCI_GetBigInt | ( | OCI_Resultset * | rs, |
unsigned int | index | ||
) |
#include <api.h>
Return the current big integer value of the column at the given index in the resultset.
rs | - Resultset handle |
index | - Column position |
OCI_SYM_PUBLIC big_int OCI_API OCI_GetBigInt2 | ( | OCI_Resultset * | rs, |
const otext * | name | ||
) |
#include <api.h>
Return the current big integer value of the column from its name in the resultset.
rs | - Resultset handle |
name | - Column name |
OCI_SYM_PUBLIC big_uint OCI_API OCI_GetUnsignedBigInt | ( | OCI_Resultset * | rs, |
unsigned int | index | ||
) |
#include <api.h>
Return the current unsigned big integer value of the column at the given index in the resultset.
rs | - Resultset handle |
index | - Column position |
OCI_SYM_PUBLIC big_uint OCI_API OCI_GetUnsignedBigInt2 | ( | OCI_Resultset * | rs, |
const otext * | name | ||
) |
#include <api.h>
Return the current unsigned big integer value of the column from its name in the resultset.
rs | - Resultset handle |
name | - Column name |
OCI_SYM_PUBLIC const otext *OCI_API OCI_GetString | ( | OCI_Resultset * | rs, |
unsigned int | index | ||
) |
#include <api.h>
Return the current string value of the column at the given index in the resultset.
rs | - Resultset handle |
index | - Column position |
OCI_SYM_PUBLIC const otext *OCI_API OCI_GetString2 | ( | OCI_Resultset * | rs, |
const otext * | name | ||
) |
#include <api.h>
Return the current string value of the column from its name in the resultset.
rs | - Resultset handle |
name | - Column name |
OCI_SYM_PUBLIC unsigned int OCI_API OCI_GetRaw | ( | OCI_Resultset * | rs, |
unsigned int | index, | ||
void * | buffer, | ||
unsigned int | len | ||
) |
#include <api.h>
Copy the current raw value of the column at the given index into the specified buffer.
rs | - Resultset handle |
index | - Column position |
buffer | - Buffer that receive the raw value |
len | - Max size of the input buffer in bytes |
OCI_SYM_PUBLIC unsigned int OCI_API OCI_GetRaw2 | ( | OCI_Resultset * | rs, |
const otext * | name, | ||
void * | buffer, | ||
unsigned int | len | ||
) |
#include <api.h>
Copy the current raw value of the column from its name into the specified buffer.
rs | - Resultset handle |
name | - Column name |
buffer | - Buffer that receive the raw value |
len | - Max size of the input buffer |
OCI_SYM_PUBLIC double OCI_API OCI_GetDouble | ( | OCI_Resultset * | rs, |
unsigned int | index | ||
) |
#include <api.h>
Return the current double value of the column at the given index in the resultset.
rs | - Resultset handle |
index | - Column position |
OCI_SYM_PUBLIC double OCI_API OCI_GetDouble2 | ( | OCI_Resultset * | rs, |
const otext * | name | ||
) |
#include <api.h>
Return the current double value of the column from its name in the resultset.
rs | - Resultset handle |
name | - Column name |
OCI_SYM_PUBLIC float OCI_API OCI_GetFloat | ( | OCI_Resultset * | rs, |
unsigned int | index | ||
) |
#include <api.h>
Return the current float value of the column at the given index in the resultset.
rs | - Resultset handle |
index | - Column position |
OCI_SYM_PUBLIC float OCI_API OCI_GetFloat2 | ( | OCI_Resultset * | rs, |
const otext * | name | ||
) |
#include <api.h>
Return the current float value of the column from its name in the resultset.
rs | - Resultset handle |
name | - Column name |
OCI_SYM_PUBLIC OCI_Date *OCI_API OCI_GetDate | ( | OCI_Resultset * | rs, |
unsigned int | index | ||
) |
#include <api.h>
Return the current date value of the column at the given index in the resultset.
rs | - Resultset handle |
index | - Column position |
OCI_SYM_PUBLIC OCI_Date *OCI_API OCI_GetDate2 | ( | OCI_Resultset * | rs, |
const otext * | name | ||
) |
#include <api.h>
Return the current date value of the column from its name in the resultset.
rs | - Resultset handle |
name | - Column name |
OCI_SYM_PUBLIC OCI_Timestamp *OCI_API OCI_GetTimestamp | ( | OCI_Resultset * | rs, |
unsigned int | index | ||
) |
#include <api.h>
Return the current timestamp value of the column at the given index in the resultset.
rs | - Resultset handle |
index | - Column position |
OCI_SYM_PUBLIC OCI_Timestamp *OCI_API OCI_GetTimestamp2 | ( | OCI_Resultset * | rs, |
const otext * | name | ||
) |
#include <api.h>
Return the current timestamp value of the column from its name in the resultset.
rs | - Resultset handle |
name | - Column name |
OCI_SYM_PUBLIC OCI_Interval *OCI_API OCI_GetInterval | ( | OCI_Resultset * | rs, |
unsigned int | index | ||
) |
#include <api.h>
Return the current interval value of the column at the given index in the resultset.
rs | - Resultset handle |
index | - Column position |
OCI_SYM_PUBLIC OCI_Interval *OCI_API OCI_GetInterval2 | ( | OCI_Resultset * | rs, |
const otext * | name | ||
) |
#include <api.h>
Return the current interval value of the column from its name in the resultset.
rs | - Resultset handle |
name | - Column name |
OCI_SYM_PUBLIC OCI_Statement *OCI_API OCI_GetStatement | ( | OCI_Resultset * | rs, |
unsigned int | index | ||
) |
#include <api.h>
Return the current cursor value (Nested table) of the column at the given index in the resultset.
rs | - Resultset handle |
index | - Column position |
OCI_SYM_PUBLIC OCI_Statement *OCI_API OCI_GetStatement2 | ( | OCI_Resultset * | rs, |
const otext * | name | ||
) |
#include <api.h>
Return the current cursor value of the column from its name in the resultset.
rs | - Resultset handle |
name | - Column name |
OCI_SYM_PUBLIC OCI_Lob *OCI_API OCI_GetLob | ( | OCI_Resultset * | rs, |
unsigned int | index | ||
) |
#include <api.h>
Return the current lob value of the column at the given index in the resultset.
rs | - Resultset handle |
index | - Column position |
OCI_SYM_PUBLIC OCI_Lob *OCI_API OCI_GetLob2 | ( | OCI_Resultset * | rs, |
const otext * | name | ||
) |
#include <api.h>
Return the current lob value of the column from its name in the resultset.
rs | - Resultset handle |
name | - Column name |
OCI_SYM_PUBLIC OCI_File *OCI_API OCI_GetFile | ( | OCI_Resultset * | rs, |
unsigned int | index | ||
) |
#include <api.h>
Return the current File value of the column at the given index in the resultset.
rs | - Resultset handle |
index | - Column position |
OCI_SYM_PUBLIC OCI_File *OCI_API OCI_GetFile2 | ( | OCI_Resultset * | rs, |
const otext * | name | ||
) |
#include <api.h>
Return the current File value of the column from its name in the resultset.
rs | - Resultset handle |
name | - Column name |
OCI_SYM_PUBLIC OCI_Object *OCI_API OCI_GetObject | ( | OCI_Resultset * | rs, |
unsigned int | index | ||
) |
#include <api.h>
Return the current Object value of the column at the given index in the resultset.
rs | - Resultset handle |
index | - Column position |
OCI_SYM_PUBLIC OCI_Object *OCI_API OCI_GetObject2 | ( | OCI_Resultset * | rs, |
const otext * | name | ||
) |
#include <api.h>
Return the current Object value of the column from its name in the resultset.
rs | - Resultset handle |
name | - Column name |
OCI_SYM_PUBLIC OCI_Coll *OCI_API OCI_GetColl | ( | OCI_Resultset * | rs, |
unsigned int | index | ||
) |
#include <api.h>
Return the current Collection value of the column at the given index in the resultset.
rs | - Resultset handle |
index | - Column position |
Referenced by ocilib::Resultset::Get().
OCI_SYM_PUBLIC OCI_Coll *OCI_API OCI_GetColl2 | ( | OCI_Resultset * | rs, |
const otext * | name | ||
) |
#include <api.h>
Return the current Collection value of the column from its name in the resultset.
rs | - Resultset handle |
name | - Column name |
Referenced by ocilib::Resultset::Get().
OCI_SYM_PUBLIC OCI_Ref *OCI_API OCI_GetRef | ( | OCI_Resultset * | rs, |
unsigned int | index | ||
) |
#include <api.h>
Return the current Ref value of the column at the given index in the resultset.
rs | - Resultset handle |
index | - Column position |
OCI_SYM_PUBLIC OCI_Ref *OCI_API OCI_GetRef2 | ( | OCI_Resultset * | rs, |
const otext * | name | ||
) |
#include <api.h>
Return the current Ref value of the column from its name in the resultset.
rs | - Resultset handle |
name | - Column name |
OCI_SYM_PUBLIC OCI_Long *OCI_API OCI_GetLong | ( | OCI_Resultset * | rs, |
unsigned int | index | ||
) |
#include <api.h>
Return the current Long value of the column at the given index in the resultset.
rs | - Resultset handle |
index | - Column position |
OCI_SYM_PUBLIC OCI_Long *OCI_API OCI_GetLong2 | ( | OCI_Resultset * | rs, |
const otext * | name | ||
) |
#include <api.h>
Return the current Long value of the column from its name in the resultset.
rs | - Resultset handle |
name | - Column name |
OCI_SYM_PUBLIC boolean OCI_API OCI_IsNull | ( | OCI_Resultset * | rs, |
unsigned int | index | ||
) |
#include <api.h>
Check if the current row value is null for the column at the given index in the resultset.
rs | - Resultset handle |
index | - Column position |
Referenced by ocilib::Resultset::IsColumnNull().
OCI_SYM_PUBLIC unsigned int OCI_API OCI_GetDataSize | ( | OCI_Resultset * | rs, |
unsigned int | index | ||
) |
#include <api.h>
Return the size of the value of the column at the given index in the resultset.
rs | - Resultset handle |
index | - Column position |
OCI_SYM_PUBLIC unsigned int OCI_API OCI_GetDataSize2 | ( | OCI_Resultset * | rs, |
const otext * | name | ||
) |
#include <api.h>
Return the size of the value of the column from its name in the resultset.
rs | - Resultset handle |
name | - Column name |
OCI_SYM_PUBLIC boolean OCI_API OCI_IsNull2 | ( | OCI_Resultset * | rs, |
const otext * | name | ||
) |
#include <api.h>
Check if the current row value is null for the column of the given name in the resultset.
rs | - Resultset handle |
name | - Column name |
Referenced by ocilib::Resultset::IsColumnNull().
OCI_SYM_PUBLIC OCI_Statement *OCI_API OCI_ResultsetGetStatement | ( | OCI_Resultset * | rs | ) |
#include <api.h>
Return the statement handle associated with a resultset handle.
rs | - resultset handle |
Referenced by ocilib::Resultset::GetStatement().
OCI_SYM_PUBLIC unsigned int OCI_API OCI_GetDataLength | ( | OCI_Resultset * | rs, |
unsigned int | index | ||
) |
#include <api.h>
Return the current row data length of the column at the given index in the resultset.
rs | - Resultset handle |
index | - Column position |