Share this page

# lrd_assign_bind_literal

Assigns a literal string to a scalar variable via its descriptor and binds it to a placeholder.

    LRDRET lrd_assign_bind_literal( LRD_CURSOR *mptCursor, char *mpszPlaceholder, char *mpcValStr, LRD_VAR_DESC *mptVarDesc, char *mpszValStrFmt, unsigned long muliOption, int miDBErrorSeverity );

mptCursor | A pointer to an LRD_CURSOR structure.
mpszPlaceholder | A pointer to a string containing the placeholder name.
mpcValStr | A pointer to the input value string, or NULL. If the value is not NULL, the string can be parameterized.
mptVarDesc | A pointer to the descriptor of a variable being bound.
mpszValStrFmt | The input value format: LRD_VAL_STR_FMT_ type where type can be DFLT or RAW.
muliOption | One of the Binding Options
miDBErrorSeverity | The Error Severity Levels of a failure in a database routine.

The lrd_assign_bind_literal function assigns function assigns a literal string value, enclosed by quotation marks, to a scalar variable via its descriptor, and then binds the variable to a placeholder in the SQL statement text. If necessary, the value is converted to the variable's type and length. The value can contain embedded null characters ('\0'). You can also specify a NULL value using NULL or 0 (without quotation marks).

The length of the string is determined by (sizeof(string) -1). This function performs the functions of both lrd_assign_literal and lrd_bind_placeholder, but it is limited to scalar type variables.

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: mpcValStr

## Example

In the following example, lrd_assign_bind_literal assigns the value 70\0\0 to the placeholder newemp. It then binds the host variable newemp_D4 to the placeholder.

    lrd_stmt(Csr1, "insert into employee values ('Joe Taylor',:newemp," "'1-JAN-97','R&D',22)", -1, 0 /*Non deferred*/, 2 /*Ora V7*/, 0);

    lrd_assign_bind_literal(Csr1, "newemp", "70\x00\x00", &newemp_D4, 0, 0, 0);

    lrd_exec(Csr1, 0, 0, 0, 0, 0);

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