note 24397 added to function.ocibindbyname

From: 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

« previous php.notes (#35056) next »