Page 1 of 1

Using PHP to insert into a CLOB and getting ORA-01461 error

Posted: Thu Oct 01, 2009 9:02 am
by Rustican
System Setup:
Oracle 10G
Apache 2.2 Web server
PHP 5

I am running a PHP web application to capture user comments and insert them into a table in my Oracle database. The table column is of type CLOB. When i execute the insert into the table i am recieving the following ORA error:

General error: 1461 OCIStmtExecute: ORA-01461: can bind a LONG value only for insert into a LONG column

Is there a better way of inserting a string greater than 4K into a CLOB type table? Are there any Oracle PHP packages and examples that i can include to help facilitate working with CLOBS?

thanks!