DBD::Informix -1820

[email protected] (Clive Eisen)
Newsgroups perl.dbi.users
Message-ID <[email protected]>
I'm using DBD::Informix and mod_perl and was having a problem with a 
-1820 error (-1820: Host variable type has been changed between fetches 
or puts) hitting a particular query on a second or subsequent execute of 
a prepared statement.

So I decided to check the DBD build and running the make test I get

t/t93lvarchar.t ..... DBD::Informix::st fetchrow_hashref failed: SQL: 
-1820: Host variable type has been changed between fetches or puts. at 
/root/.cpan/build/DBD-Informix-2008.0513-jLu21N/blib/lib/DBD/Informix/TestHarness.pm 
line 669

Which is what I'm seeing with a fetchrow_array under mod perl

IBM Informix CSDK Version 3.50, IBM Informix-ESQL Version 3.50.UC8
IBM Informix Dynamic Server Version 11.70.FC1IE
This is perl, v5.8.8 built for i386-linux-thread-multi
Client is on Centos 5.2

under mod_perl I can make the problem 'go away' by re-preparing before 
each execute, but that seems to be sub-optimal :-)

Anyone seen anything similar?

TIA

--
Clive
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.