Re: Problem: Inserted value to large

"Isaac" <piranha(remove)_at_technologist.com> wrote in message news:9m8cc2$m4d$1_at_netnews.upenn.edu...
> Hi,
> I'm using Oracle Objects for OLE to update a column that is of type CHAR
> (1), i.e. 1-byte char. When I call ODynaset::SetFieldValue(..., 'Y')
(i.e.
> I want to set the value to character 'Y') it gives me this error:
>
> ORA-01401: inserted value too large for column
>
> If I issue a SQL statement in SQL*Plus to update the column with the value
Y
> it works.
>
> Can anyone please help? I would greatly appreciate it.
>
> Thanks in advance,
> Isaac
>

Parameter to ODynaset::SetFieldValue should be null-terminated string, not char type, ie. ODynaset::SetFieldValue(index, "Y");

Boris Received on Mon Aug 27 2001 - 10:11:33 CEST