OCISTMTEXECUTE with OCIBindDynamic may fail in the following
reason.
The current DB2CI driver is not reusing the data specified via
OCIBindDynamic when a place holder is used more than once in an
SQL statement.
example)
The following sql has :varname and it is binded using
OCIBindDynamic
select * from t where c1 = :varname and c2 = :varname
And the following kind of error occurs.
OCI8 DEBUG: OCIStmtExecute at
(/usr/src/redhat/BUILD/oci8-1.4.9/oci8_statement.c:472)
OCI8 DEBUG
(/usr/src/redhat/BUILD/oci8-1.4.9/oci8.c:2006:php_oci_error)
OCI_NEED_DATA
And you can observe the error in OCI trace.
OCIBindByName( bind=&00002b88f6842c10 )
<--- OCI_SUCCESS Time elapsed - +7.600000E-005 seconds
OCIBindDynamic( bindp=&00002b88f6842c10,
errhp=&00002b88f6879680, ictxp=&000000000380b0b8,
icbfp=&00002b88ee1cbe70, octxp=&000000000380b0b8,
ocbfp=&00002b88ee1d17a0 )
---> Time elapsed - +1.370000E-004 seconds
OCIBindDynamic( )
<--- OCI_SUCCESS Time elapsed - +2.600000E-005 seconds
OCIAttrGet( hHandle=&00002b88f683f640,
fHandleType="OCI_HTYPE_STMT", pValue=&000000000380b65e,
pcbValue=<NULL pointer>, fAttribute="24",
hError=&00002b88f6879680 )
---> Time elapsed - +3.300000E-005 seconds
OCIAttrGet( pValue=1 )
<--- OCI_SUCCESS Time elapsed - +5.270000E-004 seconds
OCIStmtExecute( hSvc=&00002b88f683c6c0, hStmt=&00002b88f683f640,
hError=&00002b88f6879680, rows=0, offset=0, snapshot1=<NULL
pointer>, snapshot2=<NULL pointer>, mode=0 )
---> Time elapsed - +1.500000E-005 seconds
( Row=1, Par=1, fCType=1, OCIType=1, fSQLType=12, cbValue=-2 )
( Row=1, Par=2, fCType=1, OCIType=1, fSQLType=12, cbValue=-2 )
( Row=1, Par=3, fCType=1, OCIType=1, fSQLType=12, cbValue=-2 )
OCIStmtExecute( )
<--- OCI_NEED_DATA Time elapsed - +4.750000E-004 seconds |
