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 );

mpvLRDDBIHandleSvcCtxA pointer to an LRDDBI Service Context Handle with a valid Server Handle attribute.
mpvLRDDBIHandleLobA pointer to an LRDDBI Lob Descriptor Handle.
mjCsidThe character set ID.
mjCsfrmThe character set form.
mjLobtypeLob type. Either character LOB or binary LOB.
mjCacheWrite (True) or don't write (False) the temporary LOB to cache.
mjDurationDuration 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);