Go to the source code of this file.
Classes | |
struct | TZSQLVar |
Declares SQL Object. More... | |
struct | TZSQLVars |
Typedefs | |
typedef TZSQLVar * | PZSQLVar |
typedef TZSQLVars * | PZSQLVars |
Functions | |
AllocateOracleSQLVars (PZSQLVars &Variables, Integer Count) | |
Allocates memory for Oracle SQL Variables. | |
AllocateOracleStatementHandles (IZOraclePlainDriver PlainDriver, IZConnection Connection, POCIStmt &Handle, POCIError &ErrorHandle) | |
Allocates in memory Oracle handlers for Statement object. | |
Integer | CalculateSQLVarsSize (Integer Count) |
Calculates size of SQLVars record. | |
CheckOracleError (IZOraclePlainDriver PlainDriver, POCIError ErrorHandle, Integer Status, TZLoggingCategory LogCategory, string LogMessage) | |
Checks for possible SQL errors. | |
TZSQLType | ConvertMySQLHandleToSQLType (IZMySQLPlainDriver PlainDriver, PZMySQLField FieldHandle, Integer FieldFlags) |
Silent exception. | |
TZSQLType | ConvertOracleTypeToSQLType (string TypeName, Integer Size, Integer Precision) |
Converts a MySQL native types into ZDBC SQL types. | |
IZResultSet | CreateOracleResultSet (IZOraclePlainDriver PlainDriver, IZStatement Statement, string SQL, POCIStmt Handle, POCIError ErrorHandle) |
Creates an Oracle result set based on the current settings. | |
ExecuteOracleStatement (IZOraclePlainDriver PlainDriver, IZConnection Connection, string SQL, POCIStmt Handle, POCIError ErrorHandle) | |
Executes an Oracle statement. | |
FreeOracleSQLVars (IZOraclePlainDriver PlainDriver, PZSQLVars &Variables) | |
Frees memory Oracle SQL Variables from the memory. | |
FreeOracleStatementHandles (IZOraclePlainDriver PlainDriver, POCIStmt &Handle, POCIError &ErrorHandle) | |
Frees from memory Oracle handlers for Statement object. | |
ub4 | GetOracleUpdateCount (IZOraclePlainDriver PlainDriver, POCIStmt Handle, POCIError ErrorHandle) |
Gets a number of updates made by executed Oracle statement. | |
InitializeOracleVar (IZOraclePlainDriver PlainDriver, IZConnection Connection, PZSQLVar &Variable, TZSQLType DataType, ub2 OracleType, Integer DataSize) | |
Allocates in memory and initializes the Oracle variable. | |
LoadOracleVars (IZOraclePlainDriver PlainDriver, IZConnection Connection, POCIError ErrorHandle, PZSQLVars Variables, TZVariantDynArray Values) | |
Loads Oracle variables binded to SQL statement with data. | |
TDateTime | OraDateToDateTime (PChar Value) |
Converts Oracle internal date into TDateTime. | |
PrepareOracleStatement (IZOraclePlainDriver PlainDriver, string SQL, POCIStmt Handle, POCIError ErrorHandle) | |
Prepares an Oracle statement. | |
UnloadOracleVars (PZSQLVars Variables) | |
Unloads Oracle variables binded to SQL statement with data. | |
Variables | |
const | MAX_SQLVAR_LIMIT = 1024 |
Definition at line 106 of file ZDbcOracleUtils.pas.
Definition at line 120 of file ZDbcOracleUtils.pas.
AllocateOracleSQLVars | ( | PZSQLVars & | Variables, | |
Integer | Count | |||
) |
Allocates memory for Oracle SQL Variables.
Variables | a pointer to array of variables. | |
Count | a number of SQL variables. |
Definition at line 350 of file ZDbcOracleUtils.pas.
AllocateOracleStatementHandles | ( | IZOraclePlainDriver | PlainDriver, | |
IZConnection | Connection, | |||
POCIStmt & | Handle, | |||
POCIError & | ErrorHandle | |||
) |
Allocates in memory Oracle handlers for Statement object.
PlainDriver | an Oracle plain driver. | |
Connection | an Oracle connection object. | |
Handle | a holder for Statement handle. | |
ErrorHandle | a holder for Error handle. |
Integer CalculateSQLVarsSize | ( | Integer | Count | ) |
Calculates size of SQLVars record.
Count | a number of variable. |
Definition at line 336 of file ZDbcOracleUtils.pas.
CheckOracleError | ( | IZOraclePlainDriver | PlainDriver, | |
POCIError | ErrorHandle, | |||
Integer | Status, | |||
TZLoggingCategory | LogCategory, | |||
string | LogMessage | |||
) |
Checks for possible SQL errors.
PlainDriver | an Oracle plain driver. | |
Handle | an Oracle error handle. | |
Status | a command return status. | |
LogCategory | a logging category. | |
LogMessage | a logging message. |
TZSQLType ConvertMySQLHandleToSQLType | ( | IZMySQLPlainDriver | PlainDriver, | |
PZMySQLField | FieldHandle, | |||
Integer | FieldFlags | |||
) |
Silent exception.
Converts a MySQL native types into ZDBC SQL types.
Converts a MySQL native types into ZDBC SQL types.
PlainDriver | a native MySQL plain driver. | |
FieldHandle | a handler to field description structure. | |
FieldFlags | field flags. |
PlainDriver | a native MySQL plain driver. | |
FieldHandle | a handler to field description structure. | |
FieldFlags | a field flags. |
Definition at line 601 of file ZDbcOracleUtils.pas.
*TZSQLType ConvertOracleTypeToSQLType | ( | string | TypeName, | |
Integer | Size, | |||
Integer | Precision | |||
) |
Converts a MySQL native types into ZDBC SQL types.
Convert string Oracle field type to SQLType.
PlainDriver | a native MySQL plain driver. | |
FieldHandle | a handler to field description structure. | |
FieldFlags | field flags. |
string | field type value |
string | field type value |
Definition at line 664 of file ZDbcOracleUtils.pas.
IZResultSet CreateOracleResultSet | ( | IZOraclePlainDriver | PlainDriver, | |
IZStatement | Statement, | |||
string | SQL, | |||
POCIStmt | Handle, | |||
POCIError | ErrorHandle | |||
) |
Creates an Oracle result set based on the current settings.
ExecuteOracleStatement | ( | IZOraclePlainDriver | PlainDriver, | |
IZConnection | Connection, | |||
string | SQL, | |||
POCIStmt | Handle, | |||
POCIError | ErrorHandle | |||
) |
Executes an Oracle statement.
PlainDriver | an Oracle plain driver. | |
Connection | an Oracle connection Object. | |
SQL | an SQL query to be prepared. | |
Handle | a holder for Statement handle. | |
ErrorHandle | a holder for Error handle. |
FreeOracleSQLVars | ( | IZOraclePlainDriver | PlainDriver, | |
PZSQLVars & | Variables | |||
) |
Frees memory Oracle SQL Variables from the memory.
PlainDriver | an Oracle plain driver. | |
Variables | a pointer to array of variables. |
Definition at line 379 of file ZDbcOracleUtils.pas.
FreeOracleStatementHandles | ( | IZOraclePlainDriver | PlainDriver, | |
POCIStmt & | Handle, | |||
POCIError & | ErrorHandle | |||
) |
Frees from memory Oracle handlers for Statement object.
PlainDriver | an Oracle plain driver. | |
Handle | a holder for Statement handle. | |
ErrorHandle | a holder for Error handle. |
ub4 GetOracleUpdateCount | ( | IZOraclePlainDriver | PlainDriver, | |
POCIStmt | Handle, | |||
POCIError | ErrorHandle | |||
) |
Gets a number of updates made by executed Oracle statement.
PlainDriver | an Oracle plain driver. | |
Handle | a holder for Statement handle. | |
ErrorHandle | a holder for Error handle. |
InitializeOracleVar | ( | IZOraclePlainDriver | PlainDriver, | |
IZConnection | Connection, | |||
PZSQLVar & | Variable, | |||
TZSQLType | DataType, | |||
ub2 | OracleType, | |||
Integer | DataSize | |||
) |
Allocates in memory and initializes the Oracle variable.
PlainDriver | an Oracle plain driver. | |
Connection | an Oracle connection Object. | |
Variable | an Oracle variable holder. | |
DataType | a DBC data type. | |
OracleType | a correspondent Oracle type. | |
DataSize | a length for string variables. |
Definition at line 420 of file ZDbcOracleUtils.pas.
LoadOracleVars | ( | IZOraclePlainDriver | PlainDriver, | |
IZConnection | Connection, | |||
POCIError | ErrorHandle, | |||
PZSQLVars | Variables, | |||
TZVariantDynArray | Values | |||
) |
Loads Oracle variables binded to SQL statement with data.
PlainDriver | an Oracle plain driver. | |
Connection | an Oracle connection Object. | |
Variables | Oracle variable holders. | |
Values | a values to be loaded. |
Definition at line 492 of file ZDbcOracleUtils.pas.
TDateTime OraDateToDateTime | ( | PChar | Value | ) |
Converts Oracle internal date into TDateTime.
Value | a pointer to Oracle internal date. |
PrepareOracleStatement | ( | IZOraclePlainDriver | PlainDriver, | |
string | SQL, | |||
POCIStmt | Handle, | |||
POCIError | ErrorHandle | |||
) |
Prepares an Oracle statement.
PlainDriver | an Oracle plain driver. | |
SQL | an SQL query to be prepared. | |
Handle | a holder for Statement handle. | |
ErrorHandle | a holder for Error handle. |
UnloadOracleVars | ( | PZSQLVars | Variables | ) |
Unloads Oracle variables binded to SQL statement with data.
Variables | Oracle variable holders. |
Definition at line 572 of file ZDbcOracleUtils.pas.
const MAX_SQLVAR_LIMIT = 1024 |
Definition at line 70 of file ZDbcOracleUtils.pas.