Listing 3: Example parameter binding code in ODBC and OCI.

(a)
retcode = SQLBindParameter(hstmt1, 1, SQL_PARAM_OUTPUT, SQL_C_SSHORT, 
                          SQL_INTEGER, 0, 0, &sParm1, 0, &cbParm1);
(b)
status = OCIBindByName(stmthp, &bnd1p, errhp, (text *) ":ENAME", 
               -1, (dvoid *) ename, enamelen+1, SQLT_STR, 
               (dvoid*)0,(ub2*)0,(ub2*)0,(ub4)0,(ub4*)0, OCI_DEFAULT))