Prepares a SQL statement or a PL/SQL block and associates it with a statement handle.
Ora8.bdh
Ora8StmtPrepare3( in hCtx : number, out hStmt : number, in sql : sql, in sKey : string optional, in nLanguage : number optional, in nMode : number optional ) : boolean;
true if successful
false otherwise
Parameter | Description |
---|---|
hCtx | Service context handle to be associated with the statement. |
hStmt | Statement handle. |
sql | SQL statement or PL/SQL block to prepare. |
sKey | For statement caching only. The key to the returned statement in the cache. This can be used for future calls to Ora8StmtPrepare3, in which case there is no need to pass in the statement text and related parameters. If the key is passed in, then the statement text and other parameters are ignored and the search is solely based on the key. |
nLanguage |
Specifies language options (optional). Possible values are:
|
nMode |
Specifies various modes of operation (optional). The possible values are:
|
var ghEnv0 : number; ghError0 : number; ghStmt0 : number; ghSvcCtx0 : number; dcltrans transaction TMain begin Ora8Init(ghEnv0, OCI_DEFAULT); Ora8HandleAlloc(ghEnv0, ghError0, OCI_HTYPE_ERROR); Ora8Logon(ghEnv0, ghSvcCtx0, "user", "password", "orclnet2"); Ora8StmtPrepare3(ghSvcCtx0, ghStmt0, sqlDelete); Ora8StmtExecute(ghSvcCtx0, ghStmt0); Ora8StmtRelease(ghStmt0); Ora8Logoff(ghSvcCtx0); Ora8HandleFree(ghError0, OCI_HTYPE_ERROR); Ora8HandleFree(ghEnv0, OCI_HTYPE_ENV); end TMain; dclsql sqlDelete: DELETE FROM persons;
Oracle Call Interface Programmer's Guide for wrapped Oracle function OCIStmtPrepare2.