OCIBindByPos problem

Hello all,

When I try to bind a character string to the SQL statement, but it always finds no data. Would anyone help me?

char *txtstmt = "SELECT USERNAME FROM TABLEA WHERE FUSERID = :1"; char *uid = "ABC";
checkerr(ctxp->errhp, OCIBindByPos(stmtp, &bnd1p, ctxp->errhp, 1,

      uid, sizeof(uid),
      SQLT_CHR, (dvoid *) 0, (ub2 *)0,
      (ub2 *)0, (ub4) 0, (ub4 *)0, OCI_DEFAULT));

Thank you very much.
Jeff. Received on Fri Oct 12 2001 - 03:38:16 CDT