Connecting to an Oracle 9i database when threading

fx has asked for the wisdom of the Perl Monks concerning the following question:

I'm currently connecting to an Oracle 9i database using DBI 1.3.9 and DBD::Oracle 1.14.

The DBD::Oracle documention states that the module provides connectivity to Oracle databases versions 7 and 8. Now, I know that DBD::Oracle 1.14 works with Oracle 9 because I'm using it but before I set my code live I want to know if it reliably works with Oracle 9 and if there's any compile/config tweaks I should be aware of.

My other query against the DBD::Oracle documentation (and I suppose therefore also the DBI documentation) is whether the ora_dbh_share connection attribute is safe to use with Oracle 9. Has anyone got any experience of this?

All this is running with Perl 5.8.2 compiled for threading on Solaris 8 for SPARC.

Many thanks,

== fx, Infinity is Colourless

Comment on Connecting to an Oracle 9i database when threading

Replies are listed 'Best First'.
Re: Connecting to an Oracle 9i database when threading by dragonchild (Archbishop) on Dec 18, 2003 at 21:41 UTC
I'm using it and I've had to do no tweaks. (It had better work cause I go live Monday!) It reliably works. I'm using Perl5.8.x compiled non-threading for Solaris9 and RH9. (Oracle9i.0.1 on Linux) ------ We are the carpenters and bricklayers of the Information Age. Please remember that I'm crufty and crochety. All opinions are purely mine and all code is untested, unless otherwise specified.	[reply]
Re: Connecting to an Oracle 9i database when threading by fx (Pilgrim) on Dec 23, 2003 at 14:19 UTC
As you will see from a later post by myself, I have been unable as yet to use `DBI` and `DBD::Oracle` with my setup. `== fx, Infinity is Colourless`	[reply]