I'm running into this issue trying to pass a string data over ~1200
characters to PDO Oci through Zend_Db.
The call itself is a simple Zend_Db_Adapter_Abstract::insert call. The code
looks like:
----------
$dbh = Db::getInstance();
$data = array (
'COLUMN' => $answer_txt, );
$dbh->insert( 'EMAIL.TABLE', $data );
---------------
The error is: ORA-01461: can bind a LONG value only for insert into a LONG
column
It only happens on data with characters >~1200 (maybe 1300) in length.
We're trying to pass in data no larger than 1500 characters to a 2000
character column.
A google and a search on the mailing list archives turned up nothing. That's
odd. I would have thought somebody else ran into this issue before
concidering Oracle limit is 4k on standard VARCHAR2 column types.
Did I miss something? Did I miss the solution somewhere? Anybody know of a
solution?
Thanks
---
Philip
[email protected]
http://www.gpcentre.net/
