note 37792 deleted from function.ocibindbyname by sixd
| From: | sixd@php.net | Date: | Wed, 20 Nov 2013 19:48:28 +0000 |
| Subject: | note 37792 deleted from function.ocibindbyname by sixd | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-197591@lists.php.net to get a copy of this message | ||
Note Submitter: adamb-php at agitate dot org dot uk
----
If you use dba_tab_columns or user_tab_columns to get the sizes of the columns into which you are
inserting data with OCIBindByName, be aware that a DATE type column is returned as 7 which is the
size of it when it is stored in oracle's internal format. The problem arises when you are in
fact inserting dates using the TO_DATE function as your bound data could be something like
"28/04/1972 12:22.13" which is larger than the width specified in the bind statement and
will get you the ever so helpful OCI error message of:
ORA-01461: can bind a LONG value only for insert into a LONG column