Share this page

# 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

Tips to improve your search results... VuGen Function Reference Version 25.1-25.3 Function Reference 25.1-25.3 All View Local Help Center View Online Help Center Version: