Re: What are DBD::Oracle's dependencies (on Linux)?

Nothing else. From the DBD::Oracle docs,

$dbh = DBI->connect("dbi:Oracle:host=myhost.com;sid=ORCL", $user, $pas
+swd);
[download]

Note "myhost.com". The database does not have to be on the local machine. DBD::Oracle will contact the database over a network or over the internet.

Comment on Re: What are DBD::Oracle's dependencies (on Linux)? Download Code

Replies are listed 'Best First'.
Re^2: What are DBD::Oracle's dependencies (on Linux)? by dragonchild (Archbishop) on Oct 01, 2004 at 18:40 UTC
You still need to install, at the least, the client software so that DBD::Oracle can link against it. Most of the DBD::*s are just layers over the client libraries. Most are written in XS, for that very reason. This, incidentally, is why most DBI work on Windows tends to use ODBC, because ActiveState has DBD::ODBC already compiled and most RDBMSes will talk in ODBC. Being right, does not endow the right to be rude; politeness costs nothing. Being unknowing, is not the same as being stupid. Expressing a contrary opinion, whether to the individual or the group, is more often a sign of deeper thought than of cantankerous belligerence. Do not mistake your goals as the only goals; your opinion as the only opinion; your confidence as correctness. Saying you know better is not the same as explaining you know better.	[reply]
Re^2: What are DBD::Oracle's dependencies (on Linux)? by nguye103 (Acolyte) on Oct 01, 2004 at 18:21 UTC
So that means that I still need to install DBD-Oracle? When I try to install DBD_Oracle, it says that the ORACLE_HOME environment variable must be set. I don't know where or how to do this. I read that I need to install the Oracle client, but I don't know where to find this.	[reply]
Re^3: What are DBD::Oracle's dependencies (on Linux)? by Anonymous Monk on Oct 02, 2004 at 07:52 UTC
The documentation tells you. See http://search.cpan.org/~timb/DBD-Oracle-1.15/Oracle.pm The ORACLE_HOME environment variable should be set correctly. In general, the value used should match the version of Oracle that was used to build DBD::Oracle. If using dynamic linking then ORACLE_HOME should match the version of Oracle that will be used to load in the Oracle client libraries (via LD_LIBRARY_PATH, ldconfig, or similar on Unix). Followed by example `$ENV{ORACLE_HOME} = '/home/oracle/product/7.x.x';` [download] Get it now?	[reply] [d/l]