Database Vuser Functions (LRD) > Alphabetical List of Functions > lrd_ora8_stmt_ext

lrd_ora8_stmt_ext

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.

Return Values

See LRD Return Values.

Parameterization

The following argument can be parameterized using standard parameterization: mpcStmtText