Hi I also get an access violation on NT4sp6, Oracle 9.0.1.1.1, Activestate build 631 (perl 5.6.1), DBI 1.14, DBD::Oracle 1.06. However it works for me if I don't specify the data type:
$sth->bind_param(2, undef); rather than $sth->bind_param(2, undef, { ora_type => ORA_BLOB, ora_field => 'T_BLOB' }); It works as expected on Solaris, Oracle 9.2.0.1.0 with perl 5.6.1, DBI 1.20, DBD::Oracle 1.12. If you want to try a later DBD::Oracle I believe you can upgrade to 1.12 from http://www.xmlproj.com/PPM/ Stu > -----Original Message----- > From: Andrew Luckovenko [mailto:[EMAIL PROTECTED]] > Sent: 20 August 2002 22:24 > To: [EMAIL PROTECTED] > Subject: DBD::Oracle blob bug > > > Hello dbi-users, > > It seems that DBD::Oracle port incorrectly handles null blobs. I > don't know if it is ActiveState specific problem. Any suggestions? > > This is perl, v5.6.1 built for MSWin32-x86-multi-thread > (with 1 registered patch, see perl -V for more detail) > > Copyright 1987-2001, Larry Wall > > Binary build 628 provided by ActiveState Tool Corp. > http://www.ActiveState.com > Built 15:41:05 Jul 4 2001 > > DBI 1.27 > DBD::Oracle8 1.06 > > taken from the ActiveState. > > -- > Best regards, > Andrew mailto:[EMAIL PROTECTED] >