Detailed Description

OcilibCApiStatements

OCILIB supports the OCI data binding APIs.

Program variables can be bound to an Oracle SQL or PL/SQL statement in order to:

Provide input data for SQL statements.
Provide input/output data for PL/SQL blocks.

OCILIB provides a set of binding functions for the following data types:

Basic data types: string (char/wchar_t *), int, float, double, raw.
Object data types: LOBs, files, longs, dates, cursors, statements, timestamps, intervals, objects.

To use binding:

Prepare a statement with OCI_Prepare() (see Executing statements).
Bind variables by calling the appropriate OCI_BindXXX() function for every input variable referenced by the SQL statement.
Set the values of the program variables.
Call OCI_Execute() as many times as needed.
Each OCI_Execute() call may be preceded by an update of the program variables (for INSERTs, for example).

Warning: Between re-executions of the same SQL statement, use OCI_BindSetNull() / OCI_BindSetNullAtPos() and OCI_BindSetNotNull() / OCI_BindSetNotNullAtPos() to update the NULL / NOT NULL status of host variables.

Bindings can be:

IN: Host variable is used as input only; not updated after statement execution.
OUT: Host variable is set during statement execution; its initial value is ignored.
IN/OUT: Host variable is both read before and updated after statement execution (default).

Use OCI_BindSetDirection() to change a host variable's bind direction after the binding call but before statement execution. Each direction mode may have a slight overhead depending on the SQL type, as OCILIB may need to perform checks, conversions, or mappings between host variables and internal buffers. To maximize performance:

Set direction mode to OCI_BDM_IN if the host variable is not updated by statement execution.
Set direction mode to OCI_BDM_OUT if the host variable value is irrelevant prior to execution.
Set direction mode to OCI_BDM_IN_OUT when the host variable is used for execution and updated afterward.

OCILIB supports the OCI array interface by binding arrays of C scalar types and OCILIB object types.

All types supported by the library can be used for array binding, except OCI_Statement and OCI_Long.
Array binding is highly efficient for bulk DML operations.
For string/RAW arrays, the input array MUST be a contiguous block of data, not an array of pointers. For example, to bind an array of 10 elements for a VARCHAR2(30) column, the bound variable should be declared as array[10][31].

OCILIB does not pre-parse statements (unlike other frameworks such as JDBC) and lets Oracle recognize input variables embedded within the SQL statements.

Bind variables must be preceded in the SQL code by the ':' character.

Oracle and OCILIB support two binding modes:

By name (default): Oracle identifies variables by their names as provided to the binding function. A variable can be bound once and referenced multiple times in the statement.
By position: Oracle binds variables by their ordinal position.

The default binding mode is OCI_BIND_BY_NAME.

When using binding by position, provide the position to OCI_BindXXX() calls through the name parameter. The bind name must be the position preceded by a colon, e.g., ':1', ':2', etc.

Internal Bind Allocation Mode

Bind variables or arrays can be internally allocated by OCILIB. Instead of allocating variables or arrays on the stack/heap in the user program, bind contents can be allocated internally, which:

Minimizes the number of program variables.
Optimizes internal memory management for arrays.

To use internal bind allocation:

Call OCI_SetBindAllocation() with the mode OCI_BAM_INTERNAL.
Pass NULL for the variable or array parameter in OCI_BindXXX() calls.
Retrieve the bind content allocated by OCILIB with OCI_BindGetData().

Internal bind allocation IS compatible with ALL array binding OCI_BindArrayOfXXX() methods.

Internal bind allocation IS NOT compatible with the following single variable bind calls:

These methods require the data sub-type (e.g., OCI_CLOB/OCI_BLOB for LOBs) to internally create variables. Since their prototypes do not include the sub-type parameter, calling them with the bind mode set to OCI_BAM_INTERNAL will raise an OCILIB error of type OCI_ERR_NULL_POINTER.

Note: Rebinding is disabled by default (see OCI_AllowRebinding()). When using the rebinding feature, a host variable re-bound to a previously allocated bind MUST be of the same data type.

Basic input bind example: #include "ocilib.h"

/* requires script demo/products.sql */

OCI_Connection *cn;

OCI_Statement *st;

int code;

void err_handler(OCI_Error *err)

{

printf("%s\n", OCI_ErrorGetString(err));

}

void get_product_name(int requested_code)

{

OCI_Resultset *rs;

code = requested_code;

OCI_Execute(st);

rs = OCI_GetResultset(st);

OCI_FetchNext(rs);

printf("product name for product code %d is %s\n", code, OCI_GetString(rs, 1));

}

int main(void)

{

if (!OCI_Initialize(err_handler, NULL, OCI_ENV_DEFAULT))

{

return EXIT_FAILURE;

}

cn = OCI_ConnectionCreate("db", "usr", "pwd", OCI_SESSION_DEFAULT);

st = OCI_StatementCreate(cn);

OCI_Prepare(st, "select name from products where code = :code");

OCI_BindInt(st, ":code", &code);

get_product_name(1);

get_product_name(2);

OCI_StatementFree(st);

OCI_ConnectionFree(cn);

OCI_Cleanup();

return EXIT_SUCCESS;

}

OCI_BindInt
OCI_SYM_PUBLIC boolean OCI_API OCI_BindInt(OCI_Statement *stmt, const otext *name, int *data)
Bind an integer variable.

OCI_ConnectionFree
OCI_SYM_PUBLIC boolean OCI_API OCI_ConnectionFree(OCI_Connection *con)
Close a physical connection to an Oracle database server.

OCI_ConnectionCreate
OCI_SYM_PUBLIC OCI_Connection *OCI_API OCI_ConnectionCreate(const otext *db, const otext *user, const otext *pwd, unsigned int mode)
Create a physical connection to an Oracle database server.

OCI_Connection
struct OCI_Connection OCI_Connection
Oracle physical connection.
Definition: types.h:124

OCI_Statement
struct OCI_Statement OCI_Statement
Oracle SQL or PL/SQL statement.
Definition: types.h:136

OCI_Error
struct OCI_Error OCI_Error
Encapsulates an Oracle or OCILIB exception.
Definition: types.h:410

OCI_Resultset
struct OCI_Resultset OCI_Resultset
Collection of output columns from a select statement.
Definition: types.h:163

OCI_ErrorGetString
OCI_SYM_PUBLIC const otext *OCI_API OCI_ErrorGetString(OCI_Error *err)
Retrieve the error message string from an error handle.

OCI_FetchNext
OCI_SYM_PUBLIC boolean OCI_API OCI_FetchNext(OCI_Resultset *rs)
Fetch the next row of the result set.

OCI_GetString
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 result set.

OCI_GetResultset
OCI_SYM_PUBLIC OCI_Resultset *OCI_API OCI_GetResultset(OCI_Statement *stmt)
Retrieve the result set handle from an executed statement.

OCI_Cleanup
OCI_SYM_PUBLIC boolean OCI_API OCI_Cleanup(void)
Clean up all resources allocated by the library.

OCI_Initialize
OCI_SYM_PUBLIC boolean OCI_API OCI_Initialize(POCI_ERROR err_handler, const otext *lib_path, unsigned int mode)
Initialize the library.

OCI_StatementCreate
OCI_SYM_PUBLIC OCI_Statement *OCI_API OCI_StatementCreate(OCI_Connection *con)
Create a statement object and return its handle.

OCI_StatementFree
OCI_SYM_PUBLIC boolean OCI_API OCI_StatementFree(OCI_Statement *stmt)
Free a statement and all resources associated with it (result sets, bind variables,...

OCI_Prepare
OCI_SYM_PUBLIC boolean OCI_API OCI_Prepare(OCI_Statement *stmt, const otext *sql)
Prepare a SQL statement or PL/SQL block.

OCI_Execute
OCI_SYM_PUBLIC boolean OCI_API OCI_Execute(OCI_Statement *stmt)
Execute a prepared SQL statement or PL/SQL block.

Array interface example: #include "ocilib.h"

/* requires script demo/products.sql */

#define ARRAY_SIZE 1000

#define STRING_SIZE 20

void err_handler(OCI_Error *err)

{

printf("%s\n", OCI_ErrorGetString(err));

}

int main(void)

{

OCI_Connection *cn;

OCI_Statement *st;

OCI_Error *err;

int tab_int[ARRAY_SIZE];

char tab_str[ARRAY_SIZE][STRING_SIZE+1];

int i;

if (!OCI_Initialize(err_handler, NULL, OCI_ENV_DEFAULT | OCI_ENV_CONTEXT))

{

return EXIT_FAILURE;

}

cn = OCI_ConnectionCreate("db", "usr", "pwd", OCI_SESSION_DEFAULT);

st = OCI_StatementCreate(cn);

OCI_Prepare(st, "insert into products values(:i, :s)");

OCI_BindArraySetSize(st, ARRAY_SIZE);

OCI_BindArrayOfInts(st, ":i", (int*)tab_int, 0);

OCI_BindArrayOfStrings(st, ":s", (char*)tab_str, STRING_SIZE, 0);

for (i = 0; i < ARRAY_SIZE; i++)

{

tab_int[i] = i + 1;

sprintf(tab_str[i], "Name %d", i + 1);

}

if (!OCI_Execute(st))

{

printf("Number of DML array errors : %d\n", OCI_GetBatchErrorCount(st));

err = OCI_GetBatchError(st);

while (err)

{

printf("Error at row %d : %s\n", OCI_ErrorGetRow(err), OCI_ErrorGetString(err));

err = OCI_GetBatchError(st);

}

}

printf("row inserted : %d\n", OCI_GetAffectedRows(st));

OCI_StatementFree(st);

OCI_ConnectionFree(cn);

OCI_Cleanup();

return EXIT_SUCCESS;

}

OCI_GetBatchErrorCount
OCI_SYM_PUBLIC unsigned int OCI_API OCI_GetBatchErrorCount(OCI_Statement *stmt)
Return the number of errors that occurred within the last DML array statement.

OCI_BindArrayOfInts
OCI_SYM_PUBLIC boolean OCI_API OCI_BindArrayOfInts(OCI_Statement *stmt, const otext *name, int *data, unsigned int nbelem)
Bind an array of integers.

OCI_GetBatchError
OCI_SYM_PUBLIC OCI_Error *OCI_API OCI_GetBatchError(OCI_Statement *stmt)
Return the first or next error that occurred within a DML array statement execution.

OCI_BindArrayOfStrings
OCI_SYM_PUBLIC boolean OCI_API OCI_BindArrayOfStrings(OCI_Statement *stmt, const otext *name, otext *data, unsigned int len, unsigned int nbelem)
Bind an array of strings.

OCI_BindArraySetSize
OCI_SYM_PUBLIC boolean OCI_API OCI_BindArraySetSize(OCI_Statement *stmt, unsigned int size)
Set the input array size for bulk operations.

OCI_ErrorGetRow
OCI_SYM_PUBLIC unsigned int OCI_API OCI_ErrorGetRow(OCI_Error *err)
Return the row index that caused an error during array DML execution.

OCI_GetAffectedRows
OCI_SYM_PUBLIC unsigned int OCI_API OCI_GetAffectedRows(OCI_Statement *stmt)
Return the number of rows affected by the SQL statement.

Internal array interface example: #include "ocilib.h"

/* requires script demo/dates.sql */

#define ARRAY_SIZE 10

void err_handler(OCI_Error *err)

{

printf("%s\n", OCI_ErrorGetString(err));

}

int main(void)

{

OCI_Connection *cn;

OCI_Statement *st;

OCI_Date ** tab;

int i;

if (!OCI_Initialize(err_handler, NULL, OCI_ENV_DEFAULT))

{

return EXIT_FAILURE;

}

cn = OCI_ConnectionCreate("db", "usr", "pwd", OCI_SESSION_DEFAULT);

st = OCI_StatementCreate(cn);

OCI_SetBindAllocation(st, OCI_BAM_INTERNAL);

OCI_Prepare(st, "insert into dates values (:tab)");

OCI_BindArraySetSize(st, ARRAY_SIZE);

OCI_BindArrayOfDates(st, ":tab", NULL, 0);

tab = (OCI_Date **)OCI_BindGetData(OCI_GetBind(st, 1));

for (i = 0; i < ARRAY_SIZE; i++)

{

OCI_DateSysDate(tab[i]);

}

OCI_Execute(st);

printf("row inserted : %d\n", OCI_GetAffectedRows(st));

OCI_StatementFree(st);

OCI_ConnectionFree(cn);

OCI_Cleanup();

return EXIT_SUCCESS;

}

OCI_GetBind
OCI_SYM_PUBLIC OCI_Bind *OCI_API OCI_GetBind(OCI_Statement *stmt, unsigned int index)
Return the bind handle at the given index in the internal array of bind handles.

OCI_BindGetData
OCI_SYM_PUBLIC void *OCI_API OCI_BindGetData(OCI_Bind *bnd)
Return the user defined data associated with a bind handle.

OCI_BindArrayOfDates
OCI_SYM_PUBLIC boolean OCI_API OCI_BindArrayOfDates(OCI_Statement *stmt, const otext *name, OCI_Date **data, unsigned int nbelem)
Bind an array of dates.

OCI_Date
struct OCI_Date OCI_Date
Oracle internal date representation.
Definition: types.h:279

OCI_DateSysDate
OCI_SYM_PUBLIC boolean OCI_API OCI_DateSysDate(OCI_Date *date)
Return the current system date/time into the date handle.

OCI_SetBindAllocation
OCI_SYM_PUBLIC boolean OCI_API OCI_SetBindAllocation(OCI_Statement *stmt, unsigned int mode)
Set the current bind allocation mode that will be used for subsequent binding calls.

Functions
OCI_SYM_PUBLIC boolean OCI_API	OCI_BindArraySetSize (OCI_Statement *stmt, unsigned int size)
	Set the input array size for bulk operations.

OCI_SYM_PUBLIC unsigned int OCI_API	OCI_BindArrayGetSize (OCI_Statement *stmt)
	Return the current input array size for bulk operations.

OCI_SYM_PUBLIC boolean OCI_API	OCI_AllowRebinding (OCI_Statement *stmt, boolean value)
	Allow different host variables to be bound using the same bind name or position between executions of a prepared statement.

OCI_SYM_PUBLIC boolean OCI_API	OCI_IsRebindingAllowed (OCI_Statement *stmt)
	Indicate if rebinding is allowed on the given statement.

OCI_SYM_PUBLIC boolean OCI_API	OCI_BindBoolean (OCI_Statement stmt, const otext name, boolean *data)
	Bind a boolean variable (PL/SQL ONLY)

OCI_SYM_PUBLIC boolean OCI_API	OCI_BindNumber (OCI_Statement stmt, const otext name, OCI_Number *data)
	Bind a Number variable.

OCI_SYM_PUBLIC boolean OCI_API	OCI_BindArrayOfNumbers (OCI_Statement stmt, const otext name, OCI_Number **data, unsigned int nbelem)
	Bind an array of Number.

OCI_SYM_PUBLIC boolean OCI_API	OCI_BindShort (OCI_Statement stmt, const otext name, short *data)
	Bind a short variable.

OCI_SYM_PUBLIC boolean OCI_API	OCI_BindArrayOfShorts (OCI_Statement stmt, const otext name, short *data, unsigned int nbelem)
	Bind an array of shorts.

OCI_SYM_PUBLIC boolean OCI_API	OCI_BindUnsignedShort (OCI_Statement stmt, const otext name, unsigned short *data)
	Bind an unsigned short variable.

OCI_SYM_PUBLIC boolean OCI_API	OCI_BindArrayOfUnsignedShorts (OCI_Statement stmt, const otext name, unsigned short *data, unsigned int nbelem)
	Bind an array of unsigned shorts.

OCI_SYM_PUBLIC boolean OCI_API	OCI_BindInt (OCI_Statement stmt, const otext name, int *data)
	Bind an integer variable.

OCI_SYM_PUBLIC boolean OCI_API	OCI_BindArrayOfInts (OCI_Statement stmt, const otext name, int *data, unsigned int nbelem)
	Bind an array of integers.

OCI_SYM_PUBLIC boolean OCI_API	OCI_BindUnsignedInt (OCI_Statement stmt, const otext name, unsigned int *data)
	Bind an unsigned integer variable.

OCI_SYM_PUBLIC boolean OCI_API	OCI_BindArrayOfUnsignedInts (OCI_Statement stmt, const otext name, unsigned int *data, unsigned int nbelem)
	Bind an array of unsigned integers.

OCI_SYM_PUBLIC boolean OCI_API	OCI_BindBigInt (OCI_Statement stmt, const otext name, big_int *data)
	Bind a big integer variable.

OCI_SYM_PUBLIC boolean OCI_API	OCI_BindArrayOfBigInts (OCI_Statement stmt, const otext name, big_int *data, unsigned int nbelem)
	Bind an array of big integers.

OCI_SYM_PUBLIC boolean OCI_API	OCI_BindUnsignedBigInt (OCI_Statement stmt, const otext name, big_uint *data)
	Bind an unsigned big integer variable.

OCI_SYM_PUBLIC boolean OCI_API	OCI_BindArrayOfUnsignedBigInts (OCI_Statement stmt, const otext name, big_uint *data, unsigned int nbelem)
	Bind an array of unsigned big integers.

OCI_SYM_PUBLIC boolean OCI_API	OCI_BindString (OCI_Statement stmt, const otext name, otext *data, unsigned int len)
	Bind a string variable.

OCI_SYM_PUBLIC boolean OCI_API	OCI_BindArrayOfStrings (OCI_Statement stmt, const otext name, otext *data, unsigned int len, unsigned int nbelem)
	Bind an array of strings.

OCI_SYM_PUBLIC boolean OCI_API	OCI_BindRaw (OCI_Statement stmt, const otext name, void *data, unsigned int len)
	Bind a raw buffer.

OCI_SYM_PUBLIC boolean OCI_API	OCI_BindArrayOfRaws (OCI_Statement stmt, const otext name, void *data, unsigned int len, unsigned int nbelem)
	Bind an array of raw buffers.

OCI_SYM_PUBLIC boolean OCI_API	OCI_BindDouble (OCI_Statement stmt, const otext name, double *data)
	Bind a double variable.

OCI_SYM_PUBLIC boolean OCI_API	OCI_BindArrayOfDoubles (OCI_Statement stmt, const otext name, double *data, unsigned int nbelem)
	Bind an array of doubles.

OCI_SYM_PUBLIC boolean OCI_API	OCI_BindFloat (OCI_Statement stmt, const otext name, float *data)
	Bind a float variable.

OCI_SYM_PUBLIC boolean OCI_API	OCI_BindArrayOfFloats (OCI_Statement stmt, const otext name, float *data, unsigned int nbelem)
	Bind an array of floats.

OCI_SYM_PUBLIC boolean OCI_API	OCI_BindDate (OCI_Statement stmt, const otext name, OCI_Date *data)
	Bind a date variable.

OCI_SYM_PUBLIC boolean OCI_API	OCI_BindArrayOfDates (OCI_Statement stmt, const otext name, OCI_Date **data, unsigned int nbelem)
	Bind an array of dates.

OCI_SYM_PUBLIC boolean OCI_API	OCI_BindTimestamp (OCI_Statement stmt, const otext name, OCI_Timestamp *data)
	Bind a timestamp variable.

OCI_SYM_PUBLIC boolean OCI_API	OCI_BindArrayOfTimestamps (OCI_Statement stmt, const otext name, OCI_Timestamp **data, unsigned int type, unsigned int nbelem)
	Bind an array of timestamp handles.

OCI_SYM_PUBLIC boolean OCI_API	OCI_BindInterval (OCI_Statement stmt, const otext name, OCI_Interval *data)
	Bind an interval variable.

OCI_SYM_PUBLIC boolean OCI_API	OCI_BindArrayOfIntervals (OCI_Statement stmt, const otext name, OCI_Interval **data, unsigned int type, unsigned int nbelem)
	Bind an array of interval handles.

OCI_SYM_PUBLIC boolean OCI_API	OCI_BindLob (OCI_Statement stmt, const otext name, OCI_Lob *data)
	Bind a Lob variable.

OCI_SYM_PUBLIC boolean OCI_API	OCI_BindArrayOfLobs (OCI_Statement stmt, const otext name, OCI_Lob **data, unsigned int type, unsigned int nbelem)
	Bind an array of Lob handles.

OCI_SYM_PUBLIC boolean OCI_API	OCI_BindFile (OCI_Statement stmt, const otext name, OCI_File *data)
	Bind a File variable.

OCI_SYM_PUBLIC boolean OCI_API	OCI_BindArrayOfFiles (OCI_Statement stmt, const otext name, OCI_File **data, unsigned int type, unsigned int nbelem)
	Bind an array of File handles.

OCI_SYM_PUBLIC boolean OCI_API	OCI_BindObject (OCI_Statement stmt, const otext name, OCI_Object *data)
	Bind an object (named type) variable.

OCI_SYM_PUBLIC boolean OCI_API	OCI_BindArrayOfObjects (OCI_Statement stmt, const otext name, OCI_Object *data, OCI_TypeInfo typinf, unsigned int nbelem)
	Bind an array of object handles.

OCI_SYM_PUBLIC boolean OCI_API	OCI_BindVector (OCI_Statement stmt, const otext name, OCI_Vector *data)
	Bind a Vector variable.

OCI_SYM_PUBLIC boolean OCI_API	OCI_BindArrayOfVectors (OCI_Statement stmt, const otext name, OCI_Vector **data, unsigned int nbelem)
	Bind an array of Vector handles.

OCI_SYM_PUBLIC boolean OCI_API	OCI_BindColl (OCI_Statement stmt, const otext name, OCI_Coll *data)
	Bind a Collection variable.

OCI_SYM_PUBLIC boolean OCI_API	OCI_BindArrayOfColls (OCI_Statement stmt, const otext name, OCI_Coll *data, OCI_TypeInfo typinf, unsigned int nbelem)
	Bind an array of Collection handles.

OCI_SYM_PUBLIC boolean OCI_API	OCI_BindRef (OCI_Statement stmt, const otext name, OCI_Ref *data)
	Bind a Ref variable.

OCI_SYM_PUBLIC boolean OCI_API	OCI_BindArrayOfRefs (OCI_Statement stmt, const otext name, OCI_Ref *data, OCI_TypeInfo typinf, unsigned int nbelem)
	Bind an array of Ref handles.

OCI_SYM_PUBLIC boolean OCI_API	OCI_BindStatement (OCI_Statement stmt, const otext name, OCI_Statement *data)
	Bind a Statement variable (PL/SQL Ref Cursor)

OCI_SYM_PUBLIC boolean OCI_API	OCI_BindLong (OCI_Statement stmt, const otext name, OCI_Long *data, unsigned int size)
	Bind a Long variable.

OCI_SYM_PUBLIC OCI_Error *OCI_API	OCI_GetBatchError (OCI_Statement *stmt)
	Return the first or next error that occurred within a DML array statement execution.

OCI_SYM_PUBLIC unsigned int OCI_API	OCI_GetBatchErrorCount (OCI_Statement *stmt)
	Return the number of errors that occurred within the last DML array statement.

OCI_SYM_PUBLIC unsigned int OCI_API	OCI_GetBindCount (OCI_Statement *stmt)
	Return the number of binds currently associated with a statement.

OCI_SYM_PUBLIC OCI_Bind *OCI_API	OCI_GetBind (OCI_Statement *stmt, unsigned int index)
	Return the bind handle at the given index in the internal array of bind handles.

OCI_SYM_PUBLIC OCI_Bind *OCI_API	OCI_GetBind2 (OCI_Statement stmt, const otext name)
	Return a bind handle from its name.

OCI_SYM_PUBLIC unsigned int OCI_API	OCI_GetBindIndex (OCI_Statement stmt, const otext name)
	Return the index of a bind from its name.

OCI_SYM_PUBLIC const otext *OCI_API	OCI_BindGetName (OCI_Bind *bnd)
	Return the name of the given bind.

OCI_SYM_PUBLIC boolean OCI_API	OCI_BindSetDirection (OCI_Bind *bnd, unsigned int direction)
	Set the direction mode of a bind handle.

OCI_SYM_PUBLIC unsigned int OCI_API	OCI_BindGetDirection (OCI_Bind *bnd)
	Get the direction mode of a bind handle.

OCI_SYM_PUBLIC unsigned int OCI_API	OCI_BindGetType (OCI_Bind *bnd)
	Return the OCILIB type of the given bind.

OCI_SYM_PUBLIC unsigned int OCI_API	OCI_BindGetSubtype (OCI_Bind *bnd)
	Return the OCILIB object subtype of the given bind.

OCI_SYM_PUBLIC unsigned int OCI_API	OCI_BindGetDataCount (OCI_Bind *bnd)
	Return the number of elements of the bind handle.

OCI_SYM_PUBLIC void *OCI_API	OCI_BindGetData (OCI_Bind *bnd)
	Return the user defined data associated with a bind handle.

OCI_SYM_PUBLIC OCI_Statement *OCI_API	OCI_BindGetStatement (OCI_Bind *bnd)
	Return the statement handle associated with a bind handle.

OCI_SYM_PUBLIC boolean OCI_API	OCI_BindSetDataSize (OCI_Bind *bnd, unsigned int size)
	Set the actual size of the element held by the given bind handle.

OCI_SYM_PUBLIC boolean OCI_API	OCI_BindSetDataSizeAtPos (OCI_Bind *bnd, unsigned int position, unsigned int size)
	Set the size of the element at the given position in the bind input array.

OCI_SYM_PUBLIC unsigned int OCI_API	OCI_BindGetDataSize (OCI_Bind *bnd)
	Return the actual size of the element held by the given bind handle.

OCI_SYM_PUBLIC unsigned int OCI_API	OCI_BindGetDataSizeAtPos (OCI_Bind *bnd, unsigned int position)
	Return the actual size of the element at the given position in the bind input array.

OCI_SYM_PUBLIC boolean OCI_API	OCI_BindSetNull (OCI_Bind *bnd)
	Set the bind variable to null.

OCI_SYM_PUBLIC boolean OCI_API	OCI_BindSetNullAtPos (OCI_Bind *bnd, unsigned int position)
	Set to null the entry in the bind variable input array.

OCI_SYM_PUBLIC boolean OCI_API	OCI_BindSetNotNull (OCI_Bind *bnd)
	Set the bind variable to NOT null.

OCI_SYM_PUBLIC boolean OCI_API	OCI_BindSetNotNullAtPos (OCI_Bind *bnd, unsigned int position)
	Set to NOT null the entry in the bind variable input array.

OCI_SYM_PUBLIC boolean OCI_API	OCI_BindIsNull (OCI_Bind *bnd)
	Check if the current value of the bound variable is marked as NULL.

OCI_SYM_PUBLIC boolean OCI_API	OCI_BindIsNullAtPos (OCI_Bind *bnd, unsigned int position)
	Check if the current entry value at the given position in the bound array is marked as NULL.

OCI_SYM_PUBLIC boolean OCI_API	OCI_BindSetCharsetForm (OCI_Bind *bnd, unsigned int csfrm)
	Set the charset form of the given character based bind variable.

OCI_SYM_PUBLIC unsigned int OCI_API	OCI_BindGetAllocationMode (OCI_Bind *bnd)
	Get the allocation mode of a bind handle.

Function Documentation

◆ OCI_BindArraySetSize()

OCI_SYM_PUBLIC boolean OCI_API OCI_BindArraySetSize	(	OCI_Statement *	stmt,
		unsigned int	size
	)

#include <api.h>

Set the input array size for bulk operations.

Parameters

stmt	- Statement handle
size	- Array size

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

Note: OCI_BindArraySetSize() is used to set the size of the input bind array when using arrays for DML statements. It MUST be called to set the maximum array size before any statement execution. This initial call must be made AFTER OCI_Prepare() and BEFORE any OCI_BindArrayOfXXX() call.; OCI_BindArraySetSize() can optionally be called before subsequent OCI_Execute() calls to specify the exact number of elements populating the input arrays for the next execution. The array size passed to subsequent calls cannot exceed the initial size; otherwise, an exception will be raised.

Returns: TRUE on success, otherwise FALSE.

Referenced by ocilib::Statement::SetBindArraySize().

◆ OCI_BindArrayGetSize()

OCI_SYM_PUBLIC unsigned int OCI_API OCI_BindArrayGetSize ( OCI_Statement * stmt )

#include <api.h>

Return the current input array size for bulk operations.

Parameters

stmt	- Statement handle

Returns: The array size value, or 0 if OCI_BindArraySetSize() has not been called.

Referenced by ocilib::Statement::GetBindArraySize().

◆ OCI_AllowRebinding()

OCI_SYM_PUBLIC boolean OCI_API OCI_AllowRebinding	(	OCI_Statement *	stmt,
		boolean	value
	)

#include <api.h>

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

Parameters

stmt	- Statement handle
value	- Rebinding mode allowed

Note: Default value is FALSE

Warning: When using rebinding feature, host variable re-bound to a previously allocated bind MUST be of the same data type !

Returns: TRUE on success, otherwise FALSE.

Referenced by ocilib::Statement::AllowRebinding().

◆ OCI_IsRebindingAllowed()

OCI_SYM_PUBLIC boolean OCI_API OCI_IsRebindingAllowed ( OCI_Statement * stmt )

#include <api.h>

Indicate if rebinding is allowed on the given statement.

Parameters

stmt	- Statement handle

Note: See OCI_AllowRebinding() for more details

Returns: TRUE if allowed otherwise FALSE

Referenced by ocilib::Statement::IsRebindingAllowed().

◆ OCI_BindBoolean()

OCI_SYM_PUBLIC boolean OCI_API OCI_BindBoolean	(	OCI_Statement *	stmt,
		const otext *	name,
		boolean *	data
	)

#include <api.h>

Bind a boolean variable (PL/SQL ONLY)

Parameters

stmt	- Statement handle
name	- Variable name
data	- Pointer to boolean variable

Note: Parameter 'data' can be NULL if the statement bind allocation mode has been set to OCI_BAM_INTERNAL.

Warning

OCI_BindBoolean() CAN ONLY BE USED for PL/SQL boolean type when calling PL/SQL procedures/function
ONLY supported by Oracle 12c and above !

Returns: TRUE on success, otherwise FALSE.

◆ OCI_BindNumber()

OCI_SYM_PUBLIC boolean OCI_API OCI_BindNumber	(	OCI_Statement *	stmt,
		const otext *	name,
		OCI_Number *	data
	)

#include <api.h>

Bind a Number variable.

Parameters

stmt	- Statement handle
name	- Variable name
data	- Pointer to short variable

Note: Parameter 'data' can be NULL if the statement bind allocation mode has been set to OCI_BAM_INTERNAL.

Returns: TRUE on success, otherwise FALSE.

◆ OCI_BindArrayOfNumbers()

OCI_SYM_PUBLIC boolean OCI_API OCI_BindArrayOfNumbers	(	OCI_Statement *	stmt,
		const otext *	name,
		OCI_Number **	data,
		unsigned int	nbelem
	)

#include <api.h>

Bind an array of Number.

Parameters

stmt	- Statement handle
name	- Variable name
data	- Array of numbers
nbelem	- Number of elements in the array (PL/SQL table only)

Warning: Parameter 'nbelem' SHOULD ONLY be USED for PL/SQL tables. For regular DML array operations, pass the value 0.

Note: Parameter 'data' can be NULL if the statement bind allocation mode has been set to OCI_BAM_INTERNAL.

Returns: TRUE on success, otherwise FALSE.

◆ OCI_BindShort()

OCI_SYM_PUBLIC boolean OCI_API OCI_BindShort	(	OCI_Statement *	stmt,
		const otext *	name,
		short *	data
	)

#include <api.h>

Bind a short variable.

Parameters

stmt	- Statement handle
name	- Variable name
data	- Pointer to short variable

Note: Parameter 'data' can be NULL if the statement bind allocation mode has been set to OCI_BAM_INTERNAL.

Returns: TRUE on success, otherwise FALSE.

◆ OCI_BindArrayOfShorts()

OCI_SYM_PUBLIC boolean OCI_API OCI_BindArrayOfShorts	(	OCI_Statement *	stmt,
		const otext *	name,
		short *	data,
		unsigned int	nbelem
	)

#include <api.h>

Bind an array of shorts.

Parameters

stmt	- Statement handle
name	- Variable name
data	- Array of shorts
nbelem	- Number of elements in the array (PL/SQL table only)

Warning: Parameter 'nbelem' SHOULD ONLY be USED for PL/SQL tables. For regular DML array operations, pass the value 0.

Note: Parameter 'data' can be NULL if the statement bind allocation mode has been set to OCI_BAM_INTERNAL.

Returns: TRUE on success, otherwise FALSE.

◆ OCI_BindUnsignedShort()

OCI_SYM_PUBLIC boolean OCI_API OCI_BindUnsignedShort	(	OCI_Statement *	stmt,
		const otext *	name,
		unsigned short *	data
	)

#include <api.h>

Bind an unsigned short variable.

Parameters

stmt	- Statement handle
name	- Variable name
data	- Pointer to unsigned short variable

Note: Parameter 'data' can be NULL if the statement bind allocation mode has been set to OCI_BAM_INTERNAL.

Returns: TRUE on success, otherwise FALSE.

◆ OCI_BindArrayOfUnsignedShorts()

OCI_SYM_PUBLIC boolean OCI_API OCI_BindArrayOfUnsignedShorts	(	OCI_Statement *	stmt,
		const otext *	name,
		unsigned short *	data,
		unsigned int	nbelem
	)

#include <api.h>

Bind an array of unsigned shorts.

Parameters

stmt	- Statement handle
name	- Variable name
data	- Array of unsigned shorts
nbelem	- Number of elements in the array (PL/SQL table only)

Warning: Parameter 'nbelem' SHOULD ONLY be USED for PL/SQL tables. For regular DML array operations, pass the value 0.

Note: Parameter 'data' can be NULL if the statement bind allocation mode has been set to OCI_BAM_INTERNAL.

Returns: TRUE on success, otherwise FALSE.

◆ OCI_BindInt()

OCI_SYM_PUBLIC boolean OCI_API OCI_BindInt	(	OCI_Statement *	stmt,
		const otext *	name,
		int *	data
	)

#include <api.h>

Bind an integer variable.

Parameters

stmt	- Statement handle
name	- Variable name
data	- Pointer to int variable

Note: Parameter 'data' can be NULL if the statement bind allocation mode has been set to OCI_BAM_INTERNAL.

Returns: TRUE on success, otherwise FALSE.

◆ OCI_BindArrayOfInts()

OCI_SYM_PUBLIC boolean OCI_API OCI_BindArrayOfInts	(	OCI_Statement *	stmt,
		const otext *	name,
		int *	data,
		unsigned int	nbelem
	)

#include <api.h>

Bind an array of integers.

Parameters

stmt	- Statement handle
name	- Variable name
data	- Array of int
nbelem	- Number of elements in the array (PL/SQL table only)

Warning: Parameter 'nbelem' SHOULD ONLY be USED for PL/SQL tables. For regular DML array operations, pass the value 0.

Note: Parameter 'data' can be NULL if the statement bind allocation mode has been set to OCI_BAM_INTERNAL.

Returns: TRUE on success, otherwise FALSE.

◆ OCI_BindUnsignedInt()

OCI_SYM_PUBLIC boolean OCI_API OCI_BindUnsignedInt	(	OCI_Statement *	stmt,
		const otext *	name,
		unsigned int *	data
	)

#include <api.h>

Bind an unsigned integer variable.

Parameters

stmt	- Statement handle
name	- Variable name
data	- Pointer to unsigned int variable

Note: Parameter 'data' can be NULL if the statement bind allocation mode has been set to OCI_BAM_INTERNAL.

Returns: TRUE on success, otherwise FALSE.

◆ OCI_BindArrayOfUnsignedInts()

OCI_SYM_PUBLIC boolean OCI_API OCI_BindArrayOfUnsignedInts	(	OCI_Statement *	stmt,
		const otext *	name,
		unsigned int *	data,
		unsigned int	nbelem
	)

#include <api.h>

Bind an array of unsigned integers.

Parameters

stmt	- Statement handle
name	- Variable name
data	- Array of unsigned int
nbelem	- Number of elements in the array (PL/SQL table only)

Warning: Parameter 'nbelem' SHOULD ONLY be USED for PL/SQL tables. For regular DML array operations, pass the value 0.

Note: Parameter 'data' can be NULL if the statement bind allocation mode has been set to OCI_BAM_INTERNAL.

Returns: TRUE on success, otherwise FALSE.

◆ OCI_BindBigInt()

OCI_SYM_PUBLIC boolean OCI_API OCI_BindBigInt	(	OCI_Statement *	stmt,
		const otext *	name,
		big_int *	data
	)

#include <api.h>

Bind a big integer variable.

Parameters

stmt	- Statement handle
name	- Variable name
data	- Pointer to big int variable

Note: Parameter 'data' can be NULL if the statement bind allocation mode has been set to OCI_BAM_INTERNAL.

Returns: TRUE on success, otherwise FALSE.

◆ OCI_BindArrayOfBigInts()

OCI_SYM_PUBLIC boolean OCI_API OCI_BindArrayOfBigInts	(	OCI_Statement *	stmt,
		const otext *	name,
		big_int *	data,
		unsigned int	nbelem
	)

#include <api.h>

Bind an array of big integers.

Parameters

stmt	- Statement handle
name	- Variable name
data	- Array of big int
nbelem	- Number of elements in the array (PL/SQL table only)

Warning: Parameter 'nbelem' SHOULD ONLY be USED for PL/SQL tables. For regular DML array operations, pass the value 0.

Note: Parameter 'data' can be NULL if the statement bind allocation mode has been set to OCI_BAM_INTERNAL.

Returns: TRUE on success, otherwise FALSE.

◆ OCI_BindUnsignedBigInt()

OCI_SYM_PUBLIC boolean OCI_API OCI_BindUnsignedBigInt	(	OCI_Statement *	stmt,
		const otext *	name,
		big_uint *	data
	)

#include <api.h>

Bind an unsigned big integer variable.

Parameters

stmt	- Statement handle
name	- Variable name
data	- Pointer to unsigned big int variable

Note: Parameter 'data' can be NULL if the statement bind allocation mode has been set to OCI_BAM_INTERNAL.

Returns: TRUE on success, otherwise FALSE.

◆ OCI_BindArrayOfUnsignedBigInts()

OCI_SYM_PUBLIC boolean OCI_API OCI_BindArrayOfUnsignedBigInts	(	OCI_Statement *	stmt,
		const otext *	name,
		big_uint *	data,
		unsigned int	nbelem
	)

#include <api.h>

Bind an array of unsigned big integers.

Parameters

stmt	- Statement handle
name	- Variable name
data	- Array of unsigned big int
nbelem	- Number of elements in the array (PL/SQL table only)

Warning: Parameter 'nbelem' SHOULD ONLY be USED for PL/SQL tables. For regular DML array operations, pass the value 0.

Note: Parameter 'data' can be NULL if the statement bind allocation mode has been set to OCI_BAM_INTERNAL.

Returns: TRUE on success, otherwise FALSE.

◆ OCI_BindString()

OCI_SYM_PUBLIC boolean OCI_API OCI_BindString	(	OCI_Statement *	stmt,
		const otext *	name,
		otext *	data,
		unsigned int	len
	)

#include <api.h>

Bind a string variable.

Parameters

stmt	- Statement handle
name	- Variable name
data	- String to bind
len	- Max length of the string (in character without the zero null terminal character)

Note: if len == 0, len is set to the string size; Parameter 'data' can be NULL if the statement bind allocation mode has been set to OCI_BAM_INTERNAL.

Returns: TRUE on success, otherwise FALSE.

◆ OCI_BindArrayOfStrings()

OCI_SYM_PUBLIC boolean OCI_API OCI_BindArrayOfStrings	(	OCI_Statement *	stmt,
		const otext *	name,
		otext *	data,
		unsigned int	len,
		unsigned int	nbelem
	)

#include <api.h>

Bind an array of strings.

Parameters

stmt	- Statement handle
name	- Variable name
data	- Array of string
len	- Max length of a single string element (in character without the zero null terminal character)
nbelem	- Number of elements in the array (PL/SQL table only)

Warning: Parameter 'nbelem' SHOULD ONLY be USED for PL/SQL tables. For regular DML array operations, pass the value 0.

Note: Parameter 'data' can be NULL if the statement bind allocation mode has been set to OCI_BAM_INTERNAL.

Warning: if len <= 0, it returns FALSE

Returns: TRUE on success, otherwise FALSE.

◆ OCI_BindRaw()

OCI_SYM_PUBLIC boolean OCI_API OCI_BindRaw	(	OCI_Statement *	stmt,
		const otext *	name,
		void *	data,
		unsigned int	len
	)

#include <api.h>

Bind a raw buffer.

Parameters

stmt	- Statement handle
name	- Variable name
data	- buffer to bind
len	- Max length of the buffer

Note: if len <= 0, it returns false; Parameter 'data' can be NULL if the statement bind allocation mode has been set to OCI_BAM_INTERNAL.

Returns: TRUE on success, otherwise FALSE.

◆ OCI_BindArrayOfRaws()

OCI_SYM_PUBLIC boolean OCI_API OCI_BindArrayOfRaws	(	OCI_Statement *	stmt,
		const otext *	name,
		void *	data,
		unsigned int	len,
		unsigned int	nbelem
	)

#include <api.h>

Bind an array of raw buffers.

Parameters

stmt	- Statement handle
name	- Variable name
data	- Array of buffers
len	- Size in bytes on a single RAW array element
nbelem	- Number of elements in the array (PL/SQL table only)

Warning: Parameter 'nbelem' SHOULD ONLY be USED for PL/SQL tables. For regular DML array operations, pass the value 0.

Note: The buffer must be a contiguous block of data elements; If len <= 0, it returns FALSE; Parameter 'data' can be NULL if the statement bind allocation mode has been set to OCI_BAM_INTERNAL.

Returns: TRUE on success, otherwise FALSE.

◆ OCI_BindDouble()

OCI_SYM_PUBLIC boolean OCI_API OCI_BindDouble	(	OCI_Statement *	stmt,
		const otext *	name,
		double *	data
	)

#include <api.h>

Bind a double variable.

Parameters

stmt	- Statement handle
name	- Variable name
data	- Pointer to double variable

Note: Parameter 'data' can be NULL if the statement bind allocation mode has been set to OCI_BAM_INTERNAL.

Returns: TRUE on success, otherwise FALSE.

◆ OCI_BindArrayOfDoubles()

OCI_SYM_PUBLIC boolean OCI_API OCI_BindArrayOfDoubles	(	OCI_Statement *	stmt,
		const otext *	name,
		double *	data,
		unsigned int	nbelem
	)

#include <api.h>

Bind an array of doubles.

Parameters

stmt	- Statement handle
name	- Variable name
data	- Array of double
nbelem	- Number of elements in the array (PL/SQL table only)

Warning: Parameter 'nbelem' SHOULD ONLY be USED for PL/SQL tables. For regular DML array operations, pass the value 0.

Note: Parameter 'data' can be NULL if the statement bind allocation mode has been set to OCI_BAM_INTERNAL.

Returns: TRUE on success, otherwise FALSE.

◆ OCI_BindFloat()

OCI_SYM_PUBLIC boolean OCI_API OCI_BindFloat	(	OCI_Statement *	stmt,
		const otext *	name,
		float *	data
	)

#include <api.h>

Bind a float variable.

Parameters

stmt	- Statement handle
name	- Variable name
data	- Pointer to float variable

Note: Parameter 'data' can be NULL if the statement bind allocation mode has been set to OCI_BAM_INTERNAL.

Returns: TRUE on success, otherwise FALSE.

◆ OCI_BindArrayOfFloats()

OCI_SYM_PUBLIC boolean OCI_API OCI_BindArrayOfFloats	(	OCI_Statement *	stmt,
		const otext *	name,
		float *	data,
		unsigned int	nbelem
	)

#include <api.h>

Bind an array of floats.

Parameters

stmt	- Statement handle
name	- Variable name
data	- Array of float
nbelem	- Number of elements in the array (PL/SQL table only)

Warning: Parameter 'nbelem' SHOULD ONLY be USED for PL/SQL tables. For regular DML array operations, pass the value 0.

Note: Parameter 'data' can be NULL if the statement bind allocation mode has been set to OCI_BAM_INTERNAL.

Returns: TRUE on success, otherwise FALSE.

◆ OCI_BindDate()

OCI_SYM_PUBLIC boolean OCI_API OCI_BindDate	(	OCI_Statement *	stmt,
		const otext *	name,
		OCI_Date *	data
	)

#include <api.h>

Bind a date variable.

Parameters

stmt	- Statement handle
name	- Variable name
data	- Date handle

Note: Parameter 'data' can be NULL if the statement bind allocation mode has been set to OCI_BAM_INTERNAL.

Returns: TRUE on success, otherwise FALSE.

◆ OCI_BindArrayOfDates()

OCI_SYM_PUBLIC boolean OCI_API OCI_BindArrayOfDates	(	OCI_Statement *	stmt,
		const otext *	name,
		OCI_Date **	data,
		unsigned int	nbelem
	)

#include <api.h>

Bind an array of dates.

Parameters

stmt	- Statement handle
name	- Variable name
data	- Array of date handle
nbelem	- Number of elements in the array (PL/SQL table only)

Warning: Parameter 'nbelem' SHOULD ONLY be USED for PL/SQL tables. For regular DML array operations, pass the value 0.

Note: Parameter 'data' can be NULL if the statement bind allocation mode has been set to OCI_BAM_INTERNAL.

Returns: TRUE on success, otherwise FALSE.

◆ OCI_BindTimestamp()

OCI_SYM_PUBLIC boolean OCI_API OCI_BindTimestamp	(	OCI_Statement *	stmt,
		const otext *	name,
		OCI_Timestamp *	data
	)

#include <api.h>

Bind a timestamp variable.

Parameters

stmt	- Statement handle
name	- Variable name
data	- Timestamp handle

Note: Parameter 'data' CANNOT be NULL; the OCI_BAM_INTERNAL bind allocation mode is NOT supported for this function.

Returns: TRUE on success, otherwise FALSE.

◆ OCI_BindArrayOfTimestamps()

OCI_SYM_PUBLIC boolean OCI_API OCI_BindArrayOfTimestamps	(	OCI_Statement *	stmt,
		const otext *	name,
		OCI_Timestamp **	data,
		unsigned int	type,
		unsigned int	nbelem
	)

#include <api.h>

Bind an array of timestamp handles.

Parameters

stmt	- Statement handle
name	- Variable name
data	- Array of Timestamp handle
type	- Timestamp type
nbelem	- Number of elements in the array (PL/SQL table only)

Warning: Parameter 'nbelem' SHOULD ONLY be USED for PL/SQL tables. For regular DML array operations, pass the value 0.

Note: See OCI_TimestampCreate() for possible values of parameter 'type'; Parameter 'data' can be NULL if the statement bind allocation mode has been set to OCI_BAM_INTERNAL.

Returns: TRUE on success, otherwise FALSE.

◆ OCI_BindInterval()

OCI_SYM_PUBLIC boolean OCI_API OCI_BindInterval	(	OCI_Statement *	stmt,
		const otext *	name,
		OCI_Interval *	data
	)

#include <api.h>

Bind an interval variable.

Parameters

stmt	- Statement handle
name	- Variable name
data	- Interval handle

Note: Parameter 'data' CANNOT be NULL; the OCI_BAM_INTERNAL bind allocation mode is NOT supported for this function.

Returns: TRUE on success, otherwise FALSE.

◆ OCI_BindArrayOfIntervals()

OCI_SYM_PUBLIC boolean OCI_API OCI_BindArrayOfIntervals	(	OCI_Statement *	stmt,
		const otext *	name,
		OCI_Interval **	data,
		unsigned int	type,
		unsigned int	nbelem
	)

#include <api.h>

Bind an array of interval handles.

Parameters

stmt	- Statement handle
name	- Variable name
data	- Array of Interval handle
type	- Interval type
nbelem	- Number of elements in the array (PL/SQL table only)

Warning: Parameter 'nbelem' SHOULD ONLY be USED for PL/SQL tables. For regular DML array operations, pass the value 0.

Note: See OCI_IntervalCreate() for possible values of parameter 'type'; Parameter 'data' can be NULL if the statement bind allocation mode has been set to OCI_BAM_INTERNAL.

Returns: TRUE on success, otherwise FALSE.

◆ OCI_BindLob()

OCI_SYM_PUBLIC boolean OCI_API OCI_BindLob	(	OCI_Statement *	stmt,
		const otext *	name,
		OCI_Lob *	data
	)

#include <api.h>

Bind a Lob variable.

Parameters

stmt	- Statement handle
name	- Variable name
data	- Lob handle

Note: Parameter 'data' CANNOT be NULL; the OCI_BAM_INTERNAL bind allocation mode is NOT supported for this function.

Returns: TRUE on success, otherwise FALSE.

◆ OCI_BindArrayOfLobs()

OCI_SYM_PUBLIC boolean OCI_API OCI_BindArrayOfLobs	(	OCI_Statement *	stmt,
		const otext *	name,
		OCI_Lob **	data,
		unsigned int	type,
		unsigned int	nbelem
	)

#include <api.h>

Bind an array of Lob handles.

Parameters

stmt	- Statement handle
name	- Variable name
data	- Array of Lob handle
type	- Lob type
nbelem	- Number of elements in the array (PL/SQL table only)

Warning: Parameter 'nbelem' SHOULD ONLY be USED for PL/SQL tables. For regular DML array operations, pass the value 0.

Note: See OCI_LobCreate() for possible values of parameter 'type'; Parameter 'data' can be NULL if the statement bind allocation mode has been set to OCI_BAM_INTERNAL.

Returns: TRUE on success, otherwise FALSE.

◆ OCI_BindFile()

OCI_SYM_PUBLIC boolean OCI_API OCI_BindFile	(	OCI_Statement *	stmt,
		const otext *	name,
		OCI_File *	data
	)

#include <api.h>

Bind a File variable.

Parameters

stmt	- Statement handle
name	- Variable name
data	- File handle

Note: Parameter 'data' CANNOT be NULL; the OCI_BAM_INTERNAL bind allocation mode is NOT supported for this function.

Returns: TRUE on success, otherwise FALSE.

◆ OCI_BindArrayOfFiles()

OCI_SYM_PUBLIC boolean OCI_API OCI_BindArrayOfFiles	(	OCI_Statement *	stmt,
		const otext *	name,
		OCI_File **	data,
		unsigned int	type,
		unsigned int	nbelem
	)

#include <api.h>

Bind an array of File handles.

Parameters

stmt	- Statement handle
name	- Variable name
data	- Array of File handle
type	- File type
nbelem	- Number of elements in the array (PL/SQL table only)

Warning: Parameter 'nbelem' SHOULD ONLY be USED for PL/SQL tables. For regular DML array operations, pass the value 0.

Note: See OCI_FileCreate() for possible values of parameter 'type'; Parameter 'data' can be NULL if the statement bind allocation mode has been set to OCI_BAM_INTERNAL.

Returns: TRUE on success, otherwise FALSE.

◆ OCI_BindObject()

OCI_SYM_PUBLIC boolean OCI_API OCI_BindObject	(	OCI_Statement *	stmt,
		const otext *	name,
		OCI_Object *	data
	)

#include <api.h>

Bind an object (named type) variable.

Parameters

stmt	- Statement handle
name	- Variable name
data	- Object handle

Note: Parameter 'data' CANNOT be NULL; the OCI_BAM_INTERNAL bind allocation mode is NOT supported for this function.

Returns: TRUE on success, otherwise FALSE.

◆ OCI_BindArrayOfObjects()

OCI_SYM_PUBLIC boolean OCI_API OCI_BindArrayOfObjects	(	OCI_Statement *	stmt,
		const otext *	name,
		OCI_Object **	data,
		OCI_TypeInfo *	typinf,
		unsigned int	nbelem
	)

#include <api.h>

Bind an array of object handles.

Parameters

stmt	- Statement handle
name	- Variable name
data	- Array of object handle
typinf	- type info handle
nbelem	- Number of elements in the array (PL/SQL table only)

Warning: Parameter 'nbelem' SHOULD ONLY be USED for PL/SQL tables. For regular DML array operations, pass the value 0.

Note: Parameter 'data' can be NULL if the statement bind allocation mode has been set to OCI_BAM_INTERNAL.

Returns: TRUE on success, otherwise FALSE.

◆ OCI_BindVector()

OCI_SYM_PUBLIC boolean OCI_API OCI_BindVector	(	OCI_Statement *	stmt,
		const otext *	name,
		OCI_Vector *	data
	)

#include <api.h>

Bind a Vector variable.

Parameters

stmt	- Statement handle
name	- Variable name
data	- Vector handle

Note: Parameter 'data' CANNOT be NULL; the OCI_BAM_INTERNAL bind allocation mode is NOT supported for this function.

Returns: TRUE on success, otherwise FALSE.

◆ OCI_BindArrayOfVectors()

OCI_SYM_PUBLIC boolean OCI_API OCI_BindArrayOfVectors	(	OCI_Statement *	stmt,
		const otext *	name,
		OCI_Vector **	data,
		unsigned int	nbelem
	)

#include <api.h>

Bind an array of Vector handles.

Parameters

stmt	- Statement handle
name	- Variable name
data	- Array of Vector handle
nbelem	- Number of elements in the array (PL/SQL table only)

Warning: Parameter 'nbelem' SHOULD ONLY be USED for PL/SQL tables. For regular DML array operations, pass the value 0.

Note: Parameter 'data' can be NULL if the statement bind allocation mode has been set to OCI_BAM_INTERNAL.

Returns: TRUE on success, otherwise FALSE.

◆ OCI_BindColl()

OCI_SYM_PUBLIC boolean OCI_API OCI_BindColl	(	OCI_Statement *	stmt,
		const otext *	name,
		OCI_Coll *	data
	)

#include <api.h>

Bind a Collection variable.

Parameters

stmt	- Statement handle
name	- Variable name
data	- Collection handle to bind

Note: Parameter 'data' CANNOT be NULL; the OCI_BAM_INTERNAL bind allocation mode is NOT supported for this function.

Returns: TRUE on success, otherwise FALSE.

Referenced by ocilib::Statement::Bind().

◆ OCI_BindArrayOfColls()

OCI_SYM_PUBLIC boolean OCI_API OCI_BindArrayOfColls	(	OCI_Statement *	stmt,
		const otext *	name,
		OCI_Coll **	data,
		OCI_TypeInfo *	typinf,
		unsigned int	nbelem
	)

#include <api.h>

Bind an array of Collection handles.

Parameters

stmt	- Statement handle
name	- Variable name
data	- Array of Collection handle
typinf	- Type info handle
nbelem	- Number of elements in the array (PL/SQL table only)

Warning: Parameter 'nbelem' SHOULD ONLY be USED for PL/SQL tables. For regular DML array operations, pass the value 0.

Note: See OCI_CollCreate() for possible values of parameter 'type'; Parameter 'data' can be NULL if the statement bind allocation mode has been set to OCI_BAM_INTERNAL.

Returns: TRUE on success, otherwise FALSE.

Referenced by ocilib::Statement::Bind().

◆ OCI_BindRef()

OCI_SYM_PUBLIC boolean OCI_API OCI_BindRef	(	OCI_Statement *	stmt,
		const otext *	name,
		OCI_Ref *	data
	)

#include <api.h>

Bind a Ref variable.

Parameters

stmt	- Statement handle
name	- Variable name
data	- Ref handle to bind

Note: Parameter 'data' CANNOT be NULL; the OCI_BAM_INTERNAL bind allocation mode is NOT supported for this function.

Returns: TRUE on success, otherwise FALSE.

◆ OCI_BindArrayOfRefs()

OCI_SYM_PUBLIC boolean OCI_API OCI_BindArrayOfRefs	(	OCI_Statement *	stmt,
		const otext *	name,
		OCI_Ref **	data,
		OCI_TypeInfo *	typinf,
		unsigned int	nbelem
	)

#include <api.h>

Bind an array of Ref handles.

Parameters

stmt	- Statement handle
name	- Variable name
data	- Array of Ref handle
typinf	- type info handle
nbelem	- Number of elements in the array (PL/SQL table only)

Warning: Parameter 'nbelem' SHOULD ONLY be USED for PL/SQL tables. For regular DML array operations, pass the value 0.

Note: Parameter 'data' can be NULL if the statement bind allocation mode has been set to OCI_BAM_INTERNAL.

Returns: TRUE on success, otherwise FALSE.

◆ OCI_BindStatement()

OCI_SYM_PUBLIC boolean OCI_API OCI_BindStatement	(	OCI_Statement *	stmt,
		const otext *	name,
		OCI_Statement *	data
	)

#include <api.h>

Bind a Statement variable (PL/SQL Ref Cursor)

Parameters

stmt	- Statement handle
name	- Variable name
data	- Statement handle to bind

Note: Parameter 'data' CANNOT be NULL; the OCI_BAM_INTERNAL bind allocation mode is NOT supported for this function.

Returns: TRUE on success, otherwise FALSE.

◆ OCI_BindLong()

OCI_SYM_PUBLIC boolean OCI_API OCI_BindLong	(	OCI_Statement *	stmt,
		const otext *	name,
		OCI_Long *	data,
		unsigned int	size
	)

#include <api.h>

Bind a Long variable.

Parameters

stmt	- Statement handle
name	- Variable name
data	- Long handle
size	- Size of the long buffer in bytes or characters

Note

Size is expressed in:

Bytes for BLONGs
Characters for CLONGs

Parameter 'data' CANNOT be NULL regardless of the statement bind allocation mode.

Returns: TRUE on success, otherwise FALSE.

◆ OCI_GetBatchError()

OCI_SYM_PUBLIC OCI_Error *OCI_API OCI_GetBatchError ( OCI_Statement * stmt )

#include <api.h>

Return the first or next error that occurred within a DML array statement execution.

Parameters

stmt	- Statement handle

Returns: The first or next error handle, or NULL when no more errors are available.

Referenced by ocilib::Statement::GetBatchErrors().

◆ OCI_GetBatchErrorCount()

OCI_SYM_PUBLIC unsigned int OCI_API OCI_GetBatchErrorCount ( OCI_Statement * stmt )

#include <api.h>

Return the number of errors that occurred within the last DML array statement.

Parameters

stmt	- Statement handle

Returns: The number of errors.

◆ OCI_GetBindCount()

OCI_SYM_PUBLIC unsigned int OCI_API OCI_GetBindCount ( OCI_Statement * stmt )

#include <api.h>

Return the number of binds currently associated with a statement.

Parameters

stmt	- Statement handle

Returns: The number of bind variables.

Referenced by ocilib::Statement::GetBindCount().

◆ OCI_GetBind()

OCI_SYM_PUBLIC OCI_Bind *OCI_API OCI_GetBind	(	OCI_Statement *	stmt,
		unsigned int	index
	)

#include <api.h>

Return the bind handle at the given index in the internal array of bind handles.

Parameters

stmt	- Statement handle
index	- Bind position (1-based)

Note: Bind handles are created sequentially. For example, the third call to an OCI_BindXXX() function generates a bind handle at index 3.

Returns: The bind handle, or NULL if the index is out of bounds.

Referenced by ocilib::Statement::GetBind().

◆ OCI_GetBind2()

OCI_SYM_PUBLIC OCI_Bind *OCI_API OCI_GetBind2	(	OCI_Statement *	stmt,
		const otext *	name
	)

#include <api.h>

Return a bind handle from its name.

Parameters

stmt	- Statement handle
name	- Bind variable name

Note: Bind names must include a colon at the beginning (e.g., ":name").

Returns: The bind handle, or NULL if not found.

Referenced by ocilib::Statement::GetBind().

◆ OCI_GetBindIndex()

OCI_SYM_PUBLIC unsigned int OCI_API OCI_GetBindIndex	(	OCI_Statement *	stmt,
		const otext *	name
	)

#include <api.h>

Return the index of a bind from its name.

Parameters

stmt	- Statement handle
name	- Bind variable name

Warning: The bind name is case-insensitive.

Note: Bind indexes are 1-based in OCILIB.

Returns: The bind index on success, or 0 if the bind does not exist or if the statement is NULL.

Referenced by ocilib::Statement::GetBindIndex().

◆ OCI_BindGetName()

OCI_SYM_PUBLIC const otext *OCI_API OCI_BindGetName ( OCI_Bind * bnd )

#include <api.h>

Return the name of the given bind.

Parameters

bnd	- Bind handle

Returns: The bind name string, or NULL on failure.

Referenced by ocilib::BindInfo::GetName().

◆ OCI_BindSetDirection()

OCI_SYM_PUBLIC boolean OCI_API OCI_BindSetDirection	(	OCI_Bind *	bnd,
		unsigned int	direction
	)

#include <api.h>

Set the direction mode of a bind handle.

Parameters

bnd	- Bind handle
direction	- direction mode

Note

Possible values for parameter 'direction' :

OCI_BDM_IN : input values (not modified by the server)
OCI_BDM_OUT : output values (modified by the server)
OCI_BDM_IN_OUT : input and output values

Default value is OCI_BDM_IN_OUT

Returns: TRUE on success, otherwise FALSE.

◆ OCI_BindGetDirection()

OCI_SYM_PUBLIC unsigned int OCI_API OCI_BindGetDirection ( OCI_Bind * bnd )

#include <api.h>

Get the direction mode of a bind handle.

Parameters

bnd	- Bind handle

Note: See OCI_BindSetDirection() for more details.

Returns: The bind direction mode on success, or OCI_UNKNOWN on failure.

Referenced by ocilib::BindInfo::GetDirection().

◆ OCI_BindGetType()

OCI_SYM_PUBLIC unsigned int OCI_API OCI_BindGetType ( OCI_Bind * bnd )

#include <api.h>

Return the OCILIB type of the given bind.

Parameters

bnd	- Bind handle

Note: Possible values are :

OCI_CDT_NUMERIC : short, int, long long, float, double
OCI_CDT_DATETIME : OCI_Date *
OCI_CDT_TEXT : otext *
OCI_CDT_LONG : OCI_Long *
OCI_CDT_CURSOR : OCI_Statement *
OCI_CDT_LOB : OCI_Lob *
OCI_CDT_FILE : OCI_File *
OCI_CDT_TIMESTAMP : OCI_Timestamp *
OCI_CDT_INTERVAL : OCI_Interval *
OCI_CDT_RAW : void *
OCI_CDT_OBJECT : OCI_Object *
OCI_CDT_COLLECTION : OCI_Coll *
OCI_CDT_REF : OCI_Ref *
OCI_CDT_BOOLEAN : boolean

Returns: The column type or OCI_CDT_UNKNOWN on error

Referenced by ocilib::BindInfo::GetType().

◆ OCI_BindGetSubtype()

OCI_SYM_PUBLIC unsigned int OCI_API OCI_BindGetSubtype ( OCI_Bind * bnd )

#include <api.h>

Return the OCILIB object subtype of the given bind.

Parameters

bnd	- Bind handle

Note

This call is valid for the following OCILIB types:
OCI_CDT_NUMERIC
OCI_CDT_LONG
OCI_CDT_LOB
OCI_CDT_FILE
OCI_CDT_TIMESTAMP
OCI_CDT_INTERVAL

For numeric binds the possible values are:

OCI_NUM_SHORT
OCI_NUM_INT
OCI_NUM_BIGINT
OCI_NUM_USHORT
OCI_NUM_UINT
OCI_NUM_BIGUINT
OCI_NUM_DOUBLE
OCI_NUM_FLOAT
OCI_NUM_NUMBER

For OCI_Long type the possible values are:

OCI_BLONG
OCI_CLONG

For OCI_Lob type the possible values are:

OCI_BLOB
OCI_CLOB
OCI_NCLOB

For OCI_File type the possible values are:

OCI_BFILE
OCI_CFILE

For OCI_Timestamp type the possible values are:

OCI_TIMESTAMP
OCI_TIMESTAMP_TZ
OCI_TIMESTAMP_LTZ

For OCI_Interval type the possible values are:

OCI_INTERVAL_YM
OCI_INTERVAL_DS

Note: For all other OCILIB types, it returns OCI_UNKNOWN.

Returns: The bind subtype, or OCI_UNKNOWN if not applicable.

Referenced by ocilib::BindInfo::GetSubType().

◆ OCI_BindGetDataCount()

OCI_SYM_PUBLIC unsigned int OCI_API OCI_BindGetDataCount ( OCI_Bind * bnd )

#include <api.h>

Return the number of elements of the bind handle.

Parameters

bnd	- Bind handle

Returns

For single binds, returns 1.
For array binds, returns the number of elements in the array.

Referenced by ocilib::BindInfo::GetDataCount().

◆ OCI_BindGetData()

OCI_SYM_PUBLIC void *OCI_API OCI_BindGetData ( OCI_Bind * bnd )

#include <api.h>

Return the user defined data associated with a bind handle.

Parameters

bnd	- Bind handle

Returns

The pointer to variable/array passed to an OCI_BindXXX() or OCI_BindArrayOfXXX() call

◆ OCI_BindGetStatement()

OCI_SYM_PUBLIC OCI_Statement *OCI_API OCI_BindGetStatement ( OCI_Bind * bnd )

#include <api.h>

Return the statement handle associated with a bind handle.

Parameters

bnd	- Bind handle

Returns: The statement handle, or NULL on failure.

Referenced by ocilib::BindInfo::GetStatement().

◆ OCI_BindSetDataSize()

OCI_SYM_PUBLIC boolean OCI_API OCI_BindSetDataSize	(	OCI_Bind *	bnd,
		unsigned int	size
	)

#include <api.h>

Set the actual size of the element held by the given bind handle.

Parameters

bnd	- bind handle
size	- data size

Note: This call is not mandatory and should ONLY be used for RAW binds to set the actual data size when it differs from the expected column or parameter size.; It also works with string-based PL/SQL tables (IN or IN/OUT, but NOT OUT), although it is not required.

Warning: For binds of type OCI_CDT_TEXT (strings), the parameter 'size' is expressed in number of characters.

Returns: TRUE on success, otherwise FALSE.

◆ OCI_BindSetDataSizeAtPos()

OCI_SYM_PUBLIC boolean OCI_API OCI_BindSetDataSizeAtPos	(	OCI_Bind *	bnd,
		unsigned int	position,
		unsigned int	size
	)

#include <api.h>

Set the size of the element at the given position in the bind input array.

Parameters

bnd	- Bind handle
position	- Position in the array (1-based)
size	- Data size

Note: See OCI_BindSetDataSize() for supported data types.

Warning: Before execution, returns the maximum default size for the bind, not the actual data size, unless a custom size has been set with OCI_BindSetDataSize() or OCI_BindSetDataSizeAtPos(). After execution, returns the actual data size.; For binds of type OCI_CDT_TEXT (strings), the parameter 'size' is expressed in number of characters.

Returns: TRUE on success, otherwise FALSE.

◆ OCI_BindGetDataSize()

OCI_SYM_PUBLIC unsigned int OCI_API OCI_BindGetDataSize ( OCI_Bind * bnd )

#include <api.h>

Return the actual size of the element held by the given bind handle.

Parameters

bnd	- Bind handle

Note: See OCI_BindSetDataSize() for supported data types.

Warning: For binds of type OCI_CDT_TEXT (strings), the returned value is expressed in number of characters.

Returns: The data size, or 0 if the bind type is not supported for this operation.

◆ OCI_BindGetDataSizeAtPos()

OCI_SYM_PUBLIC unsigned int OCI_API OCI_BindGetDataSizeAtPos	(	OCI_Bind *	bnd,
		unsigned int	position
	)

#include <api.h>

Return the actual size of the element at the given position in the bind input array.

Parameters

bnd	- Bind handle
position	- Position in the array (1-based)

Note: See OCI_BindSetDataSize() for supported data types.

Warning: For binds of type OCI_CDT_TEXT (strings), the returned value is expressed in number of characters.

Returns: The data size, or 0 if the bind type is not supported for this operation.

◆ OCI_BindSetNull()

OCI_SYM_PUBLIC boolean OCI_API OCI_BindSetNull ( OCI_Bind * bnd )

#include <api.h>

Set the bind variable to null.

Parameters

bnd	- Bind handle

Note: There is no notion of null value in C. It is necessary to explicitly tell Oracle that the bind has a null value. This must be done before calling OCI_Execute().; For handle-based data types (non-scalar types), OCILIB performs an extra check on handles and sets the bind status to null if the handle is null.

Returns: TRUE on success, otherwise FALSE.

◆ OCI_BindSetNullAtPos()

OCI_SYM_PUBLIC boolean OCI_API OCI_BindSetNullAtPos	(	OCI_Bind *	bnd,
		unsigned int	position
	)

#include <api.h>

Set to null the entry in the bind variable input array.

Parameters

bnd	- Bind handle
position	- Position in the array

Note: There is no notion of null value in C. It is necessary to explicitly tell Oracle that the bind has a null value. This must be done before calling OCI_Execute().

Warning: Position is 1-based.

Note: For handle-based data types (non-scalar types), OCILIB performs an extra check on handles and sets the bind status to null if the handle is null.

Returns: TRUE on success, otherwise FALSE.

Referenced by ocilib::BindInfo::SetDataNull().

◆ OCI_BindSetNotNull()

OCI_SYM_PUBLIC boolean OCI_API OCI_BindSetNotNull ( OCI_Bind * bnd )

#include <api.h>

Set the bind variable to NOT null.

Parameters

bnd	- Bind handle

Note: There is no notion of null value in C. It is necessary to explicitly tell Oracle that the bind has a non-null value. This must be done before calling OCI_Execute().; For handle-based data types (non-scalar types), OCILIB performs an extra check on handles and sets the bind status to null if the handle is null.

Returns: TRUE on success, otherwise FALSE.

◆ OCI_BindSetNotNullAtPos()

OCI_SYM_PUBLIC boolean OCI_API OCI_BindSetNotNullAtPos	(	OCI_Bind *	bnd,
		unsigned int	position
	)

#include <api.h>

Set to NOT null the entry in the bind variable input array.

Parameters

bnd	- Bind handle
position	- Position in the array

Note: There is no notion of null value in C. It is necessary to explicitly tell Oracle that the bind has a non-null value. This must be done before calling OCI_Execute().

Warning: Position is 1-based.

Note: For handle-based data types (non-scalar types), OCILIB performs an extra check on handles and sets the bind status to null if the handle is null.

Returns: TRUE on success, otherwise FALSE.

Referenced by ocilib::BindInfo::SetDataNull().

◆ OCI_BindIsNull()

OCI_SYM_PUBLIC boolean OCI_API OCI_BindIsNull ( OCI_Bind * bnd )

#include <api.h>

Check if the current value of the bound variable is marked as NULL.

Parameters

bnd	- Bind handle

Returns: TRUE if the value is null, otherwise FALSE.

◆ OCI_BindIsNullAtPos()

OCI_SYM_PUBLIC boolean OCI_API OCI_BindIsNullAtPos	(	OCI_Bind *	bnd,
		unsigned int	position
	)

#include <api.h>

Check if the current entry value at the given position in the bound array is marked as NULL.

Parameters

bnd	- Bind handle
position	- Position in the array (1-based)

Returns: TRUE if the value at the given position is null, otherwise FALSE.

Referenced by ocilib::BindInfo::IsDataNull().

◆ OCI_BindSetCharsetForm()

OCI_SYM_PUBLIC boolean OCI_API OCI_BindSetCharsetForm	(	OCI_Bind *	bnd,
		unsigned int	csfrm
	)

#include <api.h>

Set the charset form of the given character based bind variable.

Parameters

bnd	- Bind handle
csfrm	- charset form

Note: Possible values are:

OCI_CSF_DEFAULT : The column uses the default character set.
OCI_CSF_NATIONAL : The column uses the national character set.

Note: This call must be made after OCI_Prepare() but before OCI_Execute().

Warning

This call has no effect:

If the charset form value is out of range.
If the bind type is not OCI_CDT_TEXT or OCI_CDT_LONG.

Returns: TRUE on success, otherwise FALSE.

Referenced by ocilib::BindInfo::SetCharsetForm().

◆ OCI_BindGetAllocationMode()

OCI_SYM_PUBLIC unsigned int OCI_API OCI_BindGetAllocationMode ( OCI_Bind * bnd )

#include <api.h>

Get the allocation mode of a bind handle.

Parameters

bnd	- Bind handle

Note

Possible values are:

OCI_BAM_EXTERNAL : Bind variable is allocated by user code.
OCI_BAM_INTERNAL : Bind variable is allocated internally by OCILIB.

Returns: The allocation mode on success, or OCI_UNKNOWN on failure.

Detailed Description

Functions

Function Documentation

◆ OCI_BindArraySetSize()

◆ OCI_BindArrayGetSize()

◆ OCI_AllowRebinding()

◆ OCI_IsRebindingAllowed()

◆ OCI_BindBoolean()

◆ OCI_BindNumber()

◆ OCI_BindArrayOfNumbers()

◆ OCI_BindShort()

◆ OCI_BindArrayOfShorts()

◆ OCI_BindUnsignedShort()

◆ OCI_BindArrayOfUnsignedShorts()

◆ OCI_BindInt()

◆ OCI_BindArrayOfInts()

◆ OCI_BindUnsignedInt()

◆ OCI_BindArrayOfUnsignedInts()

◆ OCI_BindBigInt()

◆ OCI_BindArrayOfBigInts()

◆ OCI_BindUnsignedBigInt()

◆ OCI_BindArrayOfUnsignedBigInts()

◆ OCI_BindString()

◆ OCI_BindArrayOfStrings()

◆ OCI_BindRaw()

◆ OCI_BindArrayOfRaws()

◆ OCI_BindDouble()

◆ OCI_BindArrayOfDoubles()

◆ OCI_BindFloat()

◆ OCI_BindArrayOfFloats()

◆ OCI_BindDate()

◆ OCI_BindArrayOfDates()

◆ OCI_BindTimestamp()

◆ OCI_BindArrayOfTimestamps()

◆ OCI_BindInterval()

◆ OCI_BindArrayOfIntervals()

◆ OCI_BindLob()

◆ OCI_BindArrayOfLobs()

◆ OCI_BindFile()

◆ OCI_BindArrayOfFiles()

◆ OCI_BindObject()

◆ OCI_BindArrayOfObjects()

◆ OCI_BindVector()

◆ OCI_BindArrayOfVectors()

◆ OCI_BindColl()

◆ OCI_BindArrayOfColls()

◆ OCI_BindRef()

◆ OCI_BindArrayOfRefs()

◆ OCI_BindStatement()

◆ OCI_BindLong()

◆ OCI_GetBatchError()

◆ OCI_GetBatchErrorCount()

◆ OCI_GetBindCount()

◆ OCI_GetBind()

◆ OCI_GetBind2()

◆ OCI_GetBindIndex()

◆ OCI_BindGetName()

◆ OCI_BindSetDirection()

◆ OCI_BindGetDirection()

◆ OCI_BindGetType()

◆ OCI_BindGetSubtype()

◆ OCI_BindGetDataCount()

◆ OCI_BindGetData()

◆ OCI_BindGetStatement()

◆ OCI_BindSetDataSize()

◆ OCI_BindSetDataSizeAtPos()

◆ OCI_BindGetDataSize()

◆ OCI_BindGetDataSizeAtPos()

◆ OCI_BindSetNull()

◆ OCI_BindSetNullAtPos()

◆ OCI_BindSetNotNull()

◆ OCI_BindSetNotNullAtPos()

◆ OCI_BindIsNull()

◆ OCI_BindIsNullAtPos()

◆ OCI_BindSetCharsetForm()

◆ OCI_BindGetAllocationMode()