/**
* Binds a parameter to the specified variable name
*
* @param string $parameter
* @param mixed $variable
* @param int $data_type
* @param int $length
* @param array $options
* @return bool
*/
public function bindParam($parameter, &$variable, $data_type = PDO::PARAM_STR, $length = -1, $driver_options = null)
{
if ($driver_options !== null) {
throw new PDOException('$driver_options is not implemented for Oci8PDO_Statement::bindParam()');
}
//Not checking for $data_type === PDO::PARAM_INT, because this gives problems when inserting/updating integers into a VARCHAR column.
// if($data_type === PDO::PARAM_INT) {
// if($length == -1) {
// $length = strlen( (string)$variable );
// }
// return oci_bind_by_name($this->_sth, $parameter, $variable, $length, SQLT_INT);
// } else
if (is_array($variable)) {
return oci_bind_array_by_name($this->_sth, $parameter, $variable, count($variable), $length);
} else {
if ($length == -1) {
$length = strlen((string) $variable);
}
if ($data_type == Oci8PDO::PARAM_BLOB) {
$clob = oci_new_descriptor($this->_pdoOci8->getDbh(), OCI_D_LOB);
$res = oci_bind_by_name($this->_sth, $parameter, $clob, -1, OCI_B_BLOB);
$clob->writeTemporary($variable, OCI_TEMP_BLOB);
return $res;
} else {
if ($data_type == Oci8PDO::PARAM_CLOB) {
$clob = oci_new_descriptor($this->_pdoOci8->getDbh(), OCI_D_LOB);
$res = oci_bind_by_name($this->_sth, $parameter, $clob, -1, OCI_B_CLOB);
$clob->writeTemporary($variable, OCI_TEMP_CLOB);
return $res;
} else {
return oci_bind_by_name($this->_sth, $parameter, $variable, $length);
}
}
}
}
