note 37792 deleted from function.ocibindbyname by sixd

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

« previous php.notes (#197591) next »