Using PHP to insert into a CLOB and getting ORA-01461 error
Posted: Thu Oct 01, 2009 9:02 am
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!
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!