> > > Jeff, > > I upgraded to perl 5.8.3 and installed both the DBI and the > DBD::Oracle modules from your site. As you suspected, that > did not fix the problem.
Unfortunately :( > When I was running the dumpbin utility, I realized that in my > previous email I mis-typed the error message that I was > getting. It's not the OCILobAppend function, it's > OCILobWriteAppend (if that makes any difference). Never the > less, The OCILobWriteAppend function is not exported from my > OCI.dll file (the other one is). I suspected that the > software I have installed was outdated, I guess this confirms > it. So I suppose I need to get some different software > loaded on my PC. Ok -- good news and bad news. That function is in the 8.1.7.4 client lib, but I can't tell you if it was in the 8.1.7. It seems pretty obvious that it's not in the 8.1.6.x that you have. > > My next question is going to demonstrate my ignorance, but I > need to ask it. Exactly what should I be asking my IT > department to load onto my machine? I've asked them for the > "Oracle Client" software, but they don't seem to understand > what I'm asking for. They gave me this "Oracle Developer" > software and told me that the client software is included in > it. I doubt that's true though because it doesn't have any > of the directories/files that I would need to build the DBD > module myself (\LIB, \OCI, ...), so I'm assuming that there > must be something else available. I have near zero Oracle > experience, so it's possible I'm just not using the right > terminology, on the other hand, maybe they're just playing dumb. Ok -- in order to build directly, you will need the client libs and the OCI libs. They are correct that the client libs are included and they may (probably) have the option to install the OCI libs too when they do install it. Usually, you have to go into custom install or do a "full" install. That said, it's possible that with a version with out that, you'll have to back off a rev or two in DBD::Oracle to avoid that function. I would suggest that you ask them for the 8.1.7 client install and if that doesn't work (i.e. that function is not in 8.1.7 directly), then you can patch it to 8.1.7.4, I'm sure. If you have a valid license of Oracle, the 8.1.7 client should be downloadable still somewhere on Oracle's site. If not, the 9x client should work, too. Regards, Jeff > > > Thanks again for your help, > > Ron > > -----Original Message----- > From: Jeff Urlwin [mailto:[EMAIL PROTECTED] > Sent: Thursday, February 26, 2004 5:13 PM > To: Wantock, Ron L.; [EMAIL PROTECTED] > Subject: RE: Oracle with ActiveState build 8xx > > > Ron, > > > > > I hope some one can help me because I'm stuck. > > > > I'm writing a perl script that connects to an Oracle > database. I want > > > the program to be multi-threaded, so I need to use perl v5.8.x. The > > problem is that I cannot find a DBD::Oracle module for v5.8.x that > > works. > [snip] > > > > The procedure entry point OCILobAppend could not be located in the > > dynamic link library OCI.dll. > > > > Does anyone know why I'm getting this error, and/or how to > get rid of > > it? Or perhaps there is a different PPM repository that I can try > > getting the module from. > > > > I've also tried to build the module myself, but that is > presenting an > > entirely different set of problems that I'll save for a different > > posting if I can't get a pre-built module to work. > > > > I'm running: > > Windows 2000 Professional > > Oracle Developer version 6 (I'm told this contains the Oracle > > 8 client) > > ActivePerl-5.8.2.808-MSWin32-x86 > > DBI v1.39 > > DBD::Oracle v1.15 > > > > > I checked my 8.1.7.4 client library (patched server from 8.1.7) and > oci.dll > has the OCILobAppend function exported. Please check your client > version > and, if you have any version of visual C++, you can check by dumpbin > /exports oci.dll (assuming oci.dll is in the current directory). I'm > not > sure which version of oracle client OCILobAppend appeared, but this is > the > first time I've heard of this issue. > > > I believe the server that I'm trying to connecting to is running: > > Oracle8i Enterprise Edition Release 8.1.6.3.0 > > You may even be able to run the 9i client instead of the 8i client. > Should > work -- provided you have the right tnsnames, etc. > > Also, please ENSURE, that if you take a version of DBD::XXXX from my > site > (or anywhere), take the current version of DBI from that site too. > Otherwise, you can run into some binary incompatibilities. I *don't* > think > that is what you are running into, but, for example, I don't think I > *ever* > put up 1.39 on my site. 1.40 is current for the 5.8.2 versions. I do > now > have 5.8.3 (809) versions up, if that's of interest to you. I believe > there > are some serious issues with < (<= ???) 5.8.2 threads and DBI > that 5.8.3 > may > fix. See the dbi-users mailing list archives for some threads issues > raised > there. > > Regards, > > Jeff > > > > > _______________________________________________ > Perl-Win32-Database mailing list > [EMAIL PROTECTED] > To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs >
