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(?, ?, ?, ?, ?,
 ?, ?, ?)");
                $stmt->bind_param(1,reply_id.nextval,{TYPE => SQL_NUMBER});
                $stmt->bind_param(2,$REPLY,{TYPE => SQL_LONGVARCHAR});
                $stmt->bind_param(3,$myform{employee_id},{TYPE => SQL_VARCHAR});
                $stmt->bind_param(4,sysdate,{TYPE => SQL_DATE});
                $stmt->bind_param(5,$myform{threadid},{TYPE => SQL_NUMBER});
                $stmt->bind_param(6,$myform{toolid},{TYPE => SQL_NUMBER});
                $stmt->bind_param(7,$myform{iconid},{TYPE => SQL_NUMBER});
                $stmt->bind_param(8,$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)

Reply via email to