Re: Exception inserted value too large for column

You can use
substr(string_in_hand,1,column_length) in that insert.

Sanjay

"Kamel Hamard" <hamard_at_iro.umontreal.ca> wrote:
>Hi,>
>I have a exception inserted value too large for column because I attempt to
>insert a string with lenght which exceed the column size.
>
>Is it possible to cut the string automatically by oracle is it exceed the
>column size?
>
>Or have you any solution?
>
>Thanks
>
>
Received on Sun Jul 25 1999 - 14:20:34 CDT