SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01461: can bind a LONG value only for insert into a LONG column

Christy H.Dec 17 2011 — edited Dec 17 2011

Hello,

SQL> desc cvDetails
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 CD_ID                                     NOT NULL NUMBER(14)
 CV_ID                                              NUMBER(14)
 NATIONALITY                                        VARCHAR2(230)
 OBJECTIVES                                         VARCHAR2(3900)
 NAME                                               VARCHAR2(230)
 FATHERNAME                                         VARCHAR2(230)
 MOTHERNAME                                         VARCHAR2(230)
 DOB                                                VARCHAR2(230)
 GENDER                                             VARCHAR2(230)
 MSTATUS                                            VARCHAR2(230)
 PASSPORTNO                                         VARCHAR2(161)
 EMAIL                                              VARCHAR2(230)
 PHONE                                              VARCHAR2(75)
 MOBILE                                             VARCHAR2(25)
 ADDRESS                                            VARCHAR2(2500)
 STATE                                              VARCHAR2(230)
 ZIPCODE                                            VARCHAR2(230)
 CITY                                               VARCHAR2(230)
 EDUCATION                                          CLOB
 EXPERIENCE                                         CLOB
 SKILLS                                             CLOB
 LANGUAGES                                          VARCHAR2(1400)
 HOBBIES                                            VARCHAR2(3200)
 ACHIEVEMENTS                                       VARCHAR2(3900)
 REFERENCES                                         VARCHAR2(3900)

SQL> 


UserDAO.insertIntoCvDetails()java.sql.SQLException: ORA-01461: can bind a LONG value only for insert into a LONG column

There is not long data type either in my Java code or in my database then why this error is thrown?

Thanks & best regards

This post has been answered by Solomon Yakobson on Dec 17 2011

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 14 2012

Added on Dec 17 2011

12 comments

7,453 views