note 24397 added to function.ocibindbyname
| From: | max at pict dot lviv dot ua | Date: | Thu, 15 Aug 2002 09:53:54 +0000 |
| Subject: | note 24397 added to function.ocibindbyname | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-35056@lists.php.net to get a copy of this message | ||
For those, who may wish to determine column size before execution of query, I suggest to use
DBA_TAB_COLUMNS view. I did it with this function:
function db_column_size($table,$column) {
$connection = db_connect();
$query = "SELECT DATA_LENGTH FROM DBA_TAB_COLUMNS ".
"WHERE TABLE_NAME='".strtoupper($table)."' ".
"AND COLUMN_NAME='".strtoupper($column)."'";
$statement = OCIParse($connection, $query);
OCIExecute($statement);
ocifetchinto($statement,$row,OCI_ASSOC+OCI_RETURN_NULLS);
return $row["DATA_LENGTH"];
}
--
http://www.php.net/manual/en/function.ocibindbyname.php
http://master.php.net/manage/user-notes.php?action=edit+24397
http://master.php.net/manage/user-notes.php?action=delete+24397
http://master.php.net/manage/user-notes.php?action=reject+24397