Share this page

# lrd_ora8_lob_create_temporary

Creates a temporary large object.

    LRDRET lrd_ora8_lob_create_temporary( void * mpvLRDDBIHandleSvcCtx, void * mpvLRDDBIHandleLob, unsigned short mjCsid, unsigned char mjCsfrm, unsigned char mjLobtype, BOOL mjCache, unsigned short mjDuration, int miDBErrorSeverity );

mpvLRDDBIHandleSvcCtx | A pointer to an LRDDBI Service Context Handle with a valid Server Handle attribute.
mpvLRDDBIHandleLob | A pointer to an LRDDBI Lob Descriptor Handle.
mjCsid | The character set ID.
mjCsfrm | The character set form.
mjLobtype | Lob type. Either character LOB or binary LOB.
mjCache | Write (True) or don't write (False) the temporary LOB to cache.
mjDuration | Duration of temporary LOB.
miDBErrorSeverity | The Error Severity Levels of a failure in a database routine.

The lrd_ora8_lob_create_temporary function creates a temporary large object descriptor (LOB).

## Return Values

See LRD Return Values.

## Parameterization

Parameterization is not applicable to this function.

## Example

In the following example, an insert statement inserts a large object (LOB) into a table. A temporary LOB is created by lrd_ora8_lob_create_temporary. The lrd_ora8_lob_write function writes a string into the LOB. This LOB is then inserted into a table.

    lrd_ora8_handle_alloc(OraEnv1, STMT, &OraStm1, 0);

    lrd_ora8_stmt(OraStm1, "insert into updtab values (NULL, :LOBVAL)", 1, 0, 0);

    lrd_ora8_handle_alloc(OraEnv1, LOB, &OraLob1, 0);

    lrd_ora8_lob_create_temporary(OraSvc2, OraLob1, 0, 1, 2, 1, 10, 0);

    lrd_ora8_lob_write(OraSvc2, OraLob1, -1, 0, 1,
        "This could be a long LOB.", -1, 0, 0, 0, 0);

    lrd_assign(&LOBVAL_D1, OraLob1, 0, 0, 0);

    lrd_ora8_bind_placeholder(OraStm1, &OraBnd1, "LOBVAL", &LOBVAL_D1, 0, 0, 0);

    lrd_ora8_exec(OraSvc2, OraStm1, 1, 0, &uliRowsProcessed, 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: