Has anyone ever upgraded DBI for Oracle8i?

I am have MAJOR problems upgrading DBI for Oracle8i on windows 2000. Even the Team Site Senior Consultant can seem to do it. Has anyone ever successfully done this??

Find more posts tagged with

Comments

Adam Stoller

I thought we shipped with an 8i DBD - why would it need to be upgraded?

Can you describe the symptoms that led you down this path?
Can you describe what's been done and how it behaved?

--fish
(Interwoven Senior Technical Consultant)

summergs

Hi Fish, THANK YOU for responding to this challenging matter! This issue is documented on Knowledge Base Article: 2444, however, I have not had much success resolving the problem as the article suggests.
To answer your questions; I wrote several simple perl scripts to retreive data from an Oracle table. Running the script(s) from the command line works perfectly, however, when you try to run the script from a DCR (via inline), the DCR starts to load and then just hangs with no error logged anywhere (even in the WiindowsOS). I then opened a ODBC connection and tried using that to connect but same results. I appears to me that Interwoven is using a Java Bridge to connect. We have our Interwoven rep at a loss, he has stated that Interwoven does not have any customers that use Oracle in a Windows Enviroment (if you can beleive that)..
Additionally, another script was written that retrieved data from the Oracle database and store it in a flat file, and then used the DCR inline to call a perl script to get the flat file data. This, of course, worked. Any assistance you can provide would be tremendously appreciated!!!!!!!!!

Adam Stoller

I don't think I can offer much direct assistance here. I'm not working in that environment and haven't done so sufficiently to be able to reel answers off the top of my head.

Generally when a DB-interactive script works from the command line and not from within a script being run from within TeamSite - it's usually a case of missing environment information (I believe I posted about this in another thread this morning).

The other thing that may be required (if you haven't already) is to load the Oracle *client* software onto the TeamSite server.

Hope the above helps - if not, hopefully someone a bit more knowledgeable with regard to DataDeploy / Oracle / Windows will be able to field this later ...

--fish
(Interwoven Senior Technical Consultant)