Re: Statement length exceeds maximum

Posted in 1998

Jonathan Leffler — Sun, 20 Sep 1998 08:02:11 -0700 — source: Informix-list mailing list archive (1991-1998)

andy_williams@my-dejanews.com wrote: > I get this error when trying to insert a 200k text file into a > text blob. I am using perl and DBD::ODBC on a winNT machine. You probably need to rewrite the INSERT to use a placeholder for the blob parameter. There are limits on the size of a single SQL statement in Informix databases, and 200k blows that limit. Also, there are no blob literals, so you have to do the insert with a placeholder. -- Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net) Guardian of DBD::Informix v0.60 -- see http://www.perl.com/CPAN #include <disclaimer.h>