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

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
Rustican
Forum Newbie
Posts: 9
Joined: Tue Jun 27, 2006 9:16 am

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

Post 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!
Post Reply