Konstantin wrote:
>
> Hi.
>
> I have changed the type of column in some table from number(10) to varchar2(50). If
>I update the column manualy with string or number values, I mean by SQL+, it's OK.
>But if I try to update the above column via Perl DBI with some string, I get the
>error 984 - cloumn not allowed here. If I update it via Perl DBI with some number,
>it's updated OK. I check the database and the type is varchar2(50) like I wanted it,
>so I can't understand what's going on. Can you please help me?
>
> Thanks in advance,
> Konstantin
>
> P.S. I sent this question to dbi-users mailing list, but no one seems to be able to
>help.
DBI makes a guess as to data type of the data based on the data itself.
When an sql statement is composed, if it looks like a number, it will
not be quoted. This will break the underlying SQL.
See the DBI docs on the bind_param function. You need to specify the
third argument to the call.
--
Matthew O. Persico
http://www.acecape.com/dsl
AceDSL:The best ADSL in Verizon area
