Assigns a NULL value to the program variable that is bound to the specified place holder in the SQL statement or PL/SQL block. The place holder is identified by the name or the number specified in the SQL statement or PL/SQL block. This function is used to assign values to both scalar and array program variables.
Ora8.bdh
Ora8SetNull( in hStmt : number, in sSqlVar : string, in nIndex : number optional): boolean;
true if successful
false otherwise. In this case, you can use the Ora8OciError function to retrieve the Oracle OCI error code
Parameter | Description |
---|---|
hStmt | Statement handle. |
sSqlVar | Name of the place holder in the SQL statement or PL/SQL block. This parameter must include the preceding colon identifying it as a place holder. |
nIndex | Array index (optional). For array binding operations, this parameter specifies the array index of the program variable. |
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, sqlInsert, OCI_NTV_SYNTAX); Ora8Bind(ghStmt0, ":name", SQLT_CHR, 32); Ora8Bind(ghStmt0, ":key", SQLT_BIN, 64); Ora8SetString(ghStmt0, ":name", "Michael"); Ora8SetNull(ghStmt0, ":age"); Ora8StmtExecute(ghSvcCtx0, ghStmt0); Ora8HandleFree(ghStmt0, OCI_HTYPE_STMT); Ora8Logoff(ghSvcCtx0); Ora8HandleFree(ghError0, OCI_HTYPE_ERROR); Ora8HandleFree(ghEnv0, OCI_HTYPE_ENV); end TMain; dclsql sqlInsert: INSERT INTO persons (name, age) VALUES (:name, :age);