------------- Begin Forwarded Message -------------
Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm List-Post: <mailto:[EMAIL PROTECTED]> List-Help: <mailto:[EMAIL PROTECTED]> List-Unsubscribe: <mailto:[EMAIL PROTECTED]> Here is my revised code still get the same error if $REPLY contains 4000 characters but not if it contains 3999. IS thisa DBD problem or oracle problem? Here is my table. REPLY_ID NOT NULL NUMBER(15) REPLY VARCHAR2(4000) REPLY_AUTHOR VARCHAR2(10) REPLY_DATE DATE THREAD_ID NOT NULL NUMBER(15) TOOL_ID NOT NULL NUMBER(15) ICON_ID NUMBER(15) CATEGORY_ID NOT NULL NUMBER(15) Here is my code: $stmt = $dbh->prepare("Insert into REPLIES values(reply_id.nextval, ?, ?, sysdate, ?, ?, ?, ?)") $stmt->bind_param(1,$REPLY,{TYPE => SQL_VARCHAR2}); $stmt->bind_param(2,$myform{employee_id},{TYPE => SQL_VARCHAR2}); $stmt->bind_param(3,$myform{threadid},{TYPE => SQL_NUMBER}); $stmt->bind_param(4,$myform{toolid},{TYPE => SQL_NUMBER}); $stmt->bind_param(5,$myform{iconid},{TYPE => SQL_NUMBER}); $stmt->bind_param(6,$myform{category_id},{TYPE => SQL_NUMBER}); $stmt->execute() or die $DBI::errstr; Here is the error: ORA-01461: can bind a LONG value only for insert into a LONG column (DBD ERROR: OCIStmtExecute)
