Binds a place holder in a SQL statement or PL/SQL block to a program variable. The variable is accessible through the Ora8Set and Ora8Get functions. The place holder is identified by the name or the number declared in the SQL statement or PL/SQL block. The functions listed below are used to assign values to the program variable that is bound to the specified place holder:
This function serves to bind place holders in SQL statements or PL/SQL blocks to both scalar and array variables. In addition, it can be used to bind place holders to be used in piecewise operations. The function must be called after preparing the SQL statement or PL/SQL block and before calling the Ora8Set function.
Ora8.bdh
Ora8BindRefCur( in hStmt : number, in sSqlVar : string, in hStmtRefCur : number): 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. |
hStmtRefCur | REF CURSOR statement handle. |