Open topic with navigation
|Example: lrd_ora8_stmt_ext||Oracle 8.0 Functions|
Prepares an SQL statement with null characters, for execution.
LRDRET lrd_ora8_stmt_ext( void *mpvLRDDBIHandleStmt, char *mpcStmtText, long mliStmtTextLen, long mliLanguage, long mliMode, int miDBErrorSeverity );
|mpvLRDDBIHandleStmt||A non-null pointer to an LRDDBI Statement Handle.|
|mpcStmtText||A pointer to null-terminated SQL statement text.|
|mliStmtTextLen||The length of the statement text.|
|mliLanguage||One of the LRD_LANGUAGE_ options.|
|mliMode||The database mode.|
|miDBErrorSeverity||The Error Severity Levels of a failure in a database routine.|
The lrd_ora8_stmt_ext function prepares an SQL or PL/SQL statement for execution. The statement text is specified by an address and an explicit length. The text may contain null characters and should be terminated with a null character. Use lrd_ora8_stmt_ext with dynamically constructed storage areas that may contain embedded null-characters.
If one lrd_ora8_stmt_ext function is followed by another (without an lrd_ora8_exec in between), the strings are concatenated. Note that a single handle can support multiple, successive SQL statements. Although you can split SQL statement text into several segments, you cannot split a placeholder identifier.
The lrd_ora8_exec function resets the contents of the SQL statement set by lrd_ora8_stmt; you must provide a new SQL statement after every lrd_ora8_exec function call.
For more details refer to the Function Header File lrd.h in the include directory.
See LRD Return Values.
The following argument can be parameterized using standard parameterization: mpcStmtText