Error - ORA-01438: value larger than specified precision allowed
577442May 14 2007 — edited May 15 2007Hi
While trying to bind (for insert) with OCI, I am repeatedly hitting with above error. My table contains field with type NUMBER (5, 0) (with precision).
While binding, I am getting this error even if I try to insert a simple integer value such as a 1 or 2. This is happening for both bind by name and position OCI calls. The bind call is pasted below,
ub2 empno;
empno = 1;
OCIBindByName(stmthp, &bndp[j], errhp, (text *) ":EMPNO, strlen(":EMPNO"), (dvoid *) &empno, sizeof(short), SQLT_INT, (dvoid *) 0, (ub2 *) 0, (ub2 *) 0, (ub4) 0, (ub4 *) 0, OCI_DEFAULT);
Any help from anyone would be deeply appreciated.