OCIStmtRelease()

Purpose

Releases the statement handle obtained by a call to OCIStmtPrepare2().

Syntax

sword OCIStmtRelease ( OCIStmt        *stmthp,  
                       OCIError       *errhp,
                       CONST OraText  *key,
                       ub4            keylen,
                       ub4            mode );  

Parameters

stmthp (IN/OUT)

The statement handle returned by OCIStmtPrepare2()

errhp (IN)

The error handle used for diagnostics.

key (IN)

Only valid for statement caching. The key to be associated with the statement in the cache. This can be the key returned by OCIStmtPrepare2() or can be a new key. If a null key is passed in the statement will not be tagged.

keylen (IN)

Only valid for statement caching. The length of the key.

mode (IN)

The valid modes are

• OCI_DEFAULT
• OCI_STMTCACHE_DELETE - Only valid for statement caching. The statement will not be kept in the cache any more.

Relateed Functions

OCIStmtPrepare2()