Re: Help.... insert into ....
From: <davide_speed_at_davidebianchi.net>
Date: 28 Apr 2002 08:31:21 GMT
Message-ID: <aagc0p$aeock$7_at_ID-18487.news.dfncis.de>
Date: 28 Apr 2002 08:31:21 GMT
Message-ID: <aagc0p$aeock$7_at_ID-18487.news.dfncis.de>
In comp.databases.oracle.misc Mridul <mridul_p_at_hotmail.com> wrote:
> I have a table in the foll format..
<ZAP>
> The error is that, on the last INSERT, I get a message that the insert
> size is more than the capacity of the column...
He is probabily trying to concatenate two "char" string of 255 and fitting them into a single varchar of 255. Try to use TRIM() to remove the empty spaces in the strings before concatenating them.
Davide Received on Sun Apr 28 2002 - 10:31:21 CEST