On Sun, Aug 21, 2005 at 05:39:39PM -0500, Paul Dyer wrote: > Hi Tim, > > Thanks for the reply. I am using Perl 5.8, Perl-DBI 1.32, DBD::Oracle > 1.16, and RedHat Linux 2.4.21-32. > > I will take another look at what could be wrong. It helps to know that > BFILE is included. I noticed that DBI has more sql_types, which include the > blob locator. I will test with some of those defined type.
Probably best not to. The DBIs sql_types are standards based whereas the BFILE support in DBD::Oracle is Oracle specific - I can't remember offhand what mapping DBD::Oracle does between the two. Possibly none. Stick to folling examples using ORA_BLOB and just change ORA_BLOB to ORA_BFILE. > I will alse try Data::Dumper to parse the returned lob locator to get the > parts. You won't get very far. It's opaque. > If I can extract the directory and filename from the lob locator > myself, then I will not need to call the dbms_lob package at all. You can't[1], so you will. Tim. [1] In theory the Oracle::OCI package could help. But there might be a significant gap between theory and practice. > Paul > > >From: Tim Bunce <[EMAIL PROTECTED]> > >To: Paul Dyer <[EMAIL PROTECTED]> > >CC: [email protected] > >Subject: Re: DBD Oracle column type > >Date: Sun, 21 Aug 2005 19:29:34 +0100 > > > >On Sat, Aug 20, 2005 at 12:31:47AM -0500, Paul Dyer wrote: > >> > >> The problem is that my column type is NOT correctly BLOB. ora_type CLOB > >and > >> BLOB are defined as integer values (112 and 113). I am using type BFILE, > >> which is 114. When I use the integer 114 as the type, I get the error > >> stating invalid entry from DBD and that it will default to SQLVARCHAR. > >> > >> Would it be possible to get the BFILE type included in the next change > >> cycle of DBD::Oracle?? > > > >Umm. The Changes file shows: > > > > =head1 Changes in DBD-Oracle 1.13 14th March 2003 > > > > ... > > Added BFILE support thanks to David Hull. > > ... > > > >Perhaps you need up upgrade. > > > >Tim. > > > >
