Re: truncated data after INSERT with undef in DBI - bug?

From: Thomas Kratz (ThomasKratz_at_REMOVEwebCAPS.de)
Date: 03/17/04 

Date: Wed, 17 Mar 2004 19:44:48 +0100

iain wrote:

> With DBI and SQL Server ODBC driver I have prepared an INSERT statement with
> placeholders. But if the first execute has a undef (aka NULL), the execute
> for the following row is truncated to just the first character for the same
> field.
>
> Has anyone else found this, or got a workaround? Is it a problem with DBI,
> the DBD::ODBC driver or the SQL Server ODBC driver or SQL Server itself?
> Is there a fix?
>
> The code below demonstrates the problem.
>
> Any ideas welcome
> thanks, Iain

[snipped code]

Looks really strange.

I don't have the time now to reproduce the problem with the code you
provided (perhaps tomorrow). But you could use the DBI trace method to
write out a detailed description of what the DBI and DBD::Oracle are
doing. Start with a low value (i.e. 3) and increase it until you see what
happens.

Thomas 

-- 
open STDIN,"<&DATA";$=+=14;$%=50;while($_=(seek( #J~.> a>n~>>e~.......>r.
STDIN,$:*$=+$,+$%,0),getc)){/\./&&last;/\w| /&&( #.u.t.^..oP..r.>h>a~.e..
print,$_=$~);/~/&&++$:;/\^/&&--$:;/>/&&++$,;/</  #.>s^~h<t< ..~. ...c.^..
&&--$,;$:%=4;$,%=23;$~=$_;++$i==1?++$,:_;}__END__#....>>e>r^..>l^...>k^..