Re: ORA-01461 problems

[Prosper]

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 <[EMAIL PROTECTED]> 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.