Prepares a SQL statement or a PL/SQL block and associates it with a statement handle.
Ora8.bdh
Ora8StmtPrepare( in hStmt : number, in sql : sql, in nLanguage : number optional, in nMode : number optional ): boolean;
true if successful
false otherwise.
Parameter | Description |
---|---|
hStmt | Statement handle. |
sql | SQL statement or PL/SQL block to prepare. |
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"); Ora8HandleAlloc(ghEnv0, ghStmt0, OCI_HTYPE_STMT); Ora8StmtPrepare(ghStmt0, sqlDelete, OCI_NTV_SYNTAX); Ora8StmtExecute(ghSvcCtx0, ghStmt0); Ora8HandleFree(ghStmt0, OCI_HTYPE_STMT); Ora8Logoff(ghSvcCtx0); Ora8HandleFree(ghError0, OCI_HTYPE_ERROR); Ora8HandleFree(ghEnv0, OCI_HTYPE_ENV); end TMain; dclsql sqlDelete: DELETE FROM persons;