Re: blob error need help

2003-02-24 Thread Jared Still
= $dbh->prepare(qq{select preview from preview where asset_id = > 'EB00000199'}); $sth->execute(); > > > > > > > > -Original Message- > From: Jenda Krynicky [mailto:[EMAIL PROTECTED] > Sent: Monday, February 17, 2003 3:45 PM > To: Scot

Re: blob error need help

2003-02-18 Thread Sumitro Chowdhury
Scott Purcell Cc: [EMAIL PROTECTED] Subject: Re: blob error need help My silly, off-the-cuff guess is that you need DBD built using OCI8 libraries. Did you build DBD yourself, or download a package? Can you build it yourself (perl Makefile.PL; make; make test; make install)? If you are using Or

Re: blob error need help

2003-02-17 Thread Dave K
Repeat the ppm exercise with DBD::Oracle8 as the target. > Hmm seems ActiveState did compile the DBD::Oracle against Oracle 7. > And none of the other PPM repositories I know of contain the module.

RE: blob error need help

2003-02-17 Thread Jenda Krynicky
From: "Scott Purcell" <[EMAIL PROTECTED]> > Good. That worked. I do have 1.12 installed now and I verified via the > ppm version check. > > But when I run my original problem, it looks like nothing has changed. > (I did get a new window before running this). > > C:\dbi_play\dbi>perl getblob > D

RE: blob error need help

2003-02-17 Thread Scott Purcell
199'}); $sth->execute(); -Original Message- From: Jenda Krynicky [mailto:[EMAIL PROTECTED]] Sent: Monday, February 17, 2003 3:45 PM To: Scott Purcell; [EMAIL PROTECTED] Subject: RE: blob error need help From: "Scott Purcell" <[EMAIL PROTECTED]> > I do not k

RE: blob error need help

2003-02-17 Thread Jenda Krynicky
From: "Scott Purcell" <[EMAIL PROTECTED]> > I do not know how to rebuild DBD::Oracle against Oracle 8i libraries > on my 2000 box. I do not think it is possible. > > I used ppm3 and did a search on the dbd-oracle. The problem is two > come up DBD-Oracle [1.12] and DBD-Oracle [1.06] The problem is

RE: blob error need help

2003-02-17 Thread Scott Purcell
select, so it keeps installing 1.06. Any more ideas? Thanks, Scott -Original Message- From: Sumitro Chowdhury [mailto:[EMAIL PROTECTED]] Sent: Monday, February 17, 2003 3:32 PM To: Scott Purcell Cc: [EMAIL PROTECTED] Subject: Re: blob error need help > > while (my $doc

RE: blob error need help

2003-02-17 Thread Scott Purcell
N Murray [mailto:[EMAIL PROTECTED]] Sent: Monday, February 17, 2003 3:00 PM To: Scott Purcell Cc: [EMAIL PROTECTED] Subject: Re: blob error need help My silly, off-the-cuff guess is that you need DBD built using OCI8 libraries. Did you build DBD yourself, or download a package? Can you build it

Re: blob error need help

2003-02-17 Thread David N Murray
My silly, off-the-cuff guess is that you need DBD built using OCI8 libraries. Did you build DBD yourself, or download a package? Can you build it yourself (perl Makefile.PL; make; make test; make install)? If you are using Oracle 8, then you have the right libraries to do the build. It looks lik

blob error need help

2003-02-17 Thread Scott Purcell
Hello, I have some (jpeg) blobs in oracle. table looks like this: asset_id height widthpreview varchar2 varchar2varchar2blob Ihave the programming DBI book here, but it does not cover this very well. I just want to select a blob and write it to a file. No big