You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user-cs@ibatis.apache.org by Eka Gautama <ek...@seatech.com> on 2006/11/14 07:36:49 UTC

ORA-01461 problems

Hi guys,

Here is the situatian. I got a table in Oracle DB with 2 columns where the types is VARCHAR2(4000). I can populate the data to the first column the whole 4000 characters, but why I can only insert 1000 characters in the second column? if I try to insert 1001 characters, I got oracle error # ORA-01461 (can bind a LONG value only for insert into LONG column). 

Thank u for the helps.

Regards

Eka

Re: ORA-01461 problems

Posted by Eka Gautama <ek...@seatech.com>.
Hi,

I am only using one table which has t columns with the datatype is VARCHAR2(4000).

Regards

Eka
  ----- Original Message ----- 
  From: Prosper 
  To: user-cs@ibatis.apache.org 
  Sent: Tuesday, November 14, 2006 3:52 PM
  Subject: Re: ORA-01461 problems


  Hi Eka,
  that may imply that the two table are not so identical;
  Mya I suggest you to suppress the problematic table, and to recreate it from the one which is ok.
  Good luck

  Eka Gautama <ek...@seatech.com> wrote:
    Hi guys,

    Here is the situatian. I got a table in Oracle DB with 2 columns where the types is VARCHAR2(4000). I can populate the data to the first column the whole 4000 characters, but why I can only insert 1000 characters in the second column? if I try to insert 1001 characters, I got oracle error # ORA-01461 (can bind a LONG value only for insert into LONG column). 

    Thank u for the helps.

    Regards

    Eka





------------------------------------------------------------------------------
  Everyone is raving about the all-new Yahoo! Mail beta.

Re: ORA-01461 problems

Posted by Prosper <mp...@yahoo.com>.
Hi Eka,
  that may imply that the two table are not so identical;
  Mya I suggest you to suppress the problematic table, and to recreate it from the one which is ok.
  Good luck

Eka Gautama <ek...@seatech.com> wrote:
          Hi guys,
   
  Here is the situatian. I got a table in Oracle DB with 2 columns where the types is VARCHAR2(4000). I can populate the data to the first column the whole 4000 characters, but why I can only insert 1000 characters in the second column? if I try to insert 1001 characters, I got oracle error # ORA-01461 (can bind a LONG value only for insert into LONG column). 
   
  Thank u for the helps.
   
  Regards
   
  Eka
   


 
---------------------------------
Everyone is raving about the all-new Yahoo! Mail beta.