Re: Help.... insert into ....

From: <davide_speed_at_davidebianchi.net>
Date: 28 Apr 2002 08:31:21 GMT
Message-ID: <aagc0p$aeock$7@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 - 03:31:21 CDT