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
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 DBD::Oracle::st execute failed: ORA-00932: inconsistent

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
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 when you try and install, it does not let you se

RE: blob error need help

2003-02-17 Thread Scott Purcell
I am using ActiveState Perl Version v5.6.1 for MSWin32-x86 on my 2000 box. The dbd was downloaded from active state also. When I vi the Oracle.pm it says Version = 1.06 I am running the Oracle 8i tools on my PC. Where should I go from here? Thanks Scott -Original Message- From: David

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

dbiproxy Problem on Win2K...

2003-02-17 Thread Tim Howell
I'm having a problem with dbiproxy on Win2K. I'm connecting to the proxy server from perl 5.8 on a linux box in order to access a MS SQL database on the Win2K box. Everything works fine for one request. After a single query has been executed dbiproxy will no longer accept requests until it is res