> http://otn.oracle.com/tech/oci/instantclient/instantclient.html
>
> "Download and be ready in seconds. Deploy your applications right
> out of the box. Deliver the promise. Free.
>
> Naturally I'd like DBD::Oracle to support "Instant Clients".
Short answer: It works on Linux, at least as far as passing make test.
Long answer:
Looks like the Oracle developers aren't talking to the documentation guys
(as usual) - the installation instructions say to 'Unzip the packages into a
single directory such as "instantclient".'.
Except it's an RPM file.
So, installed the RPM, it puts libraries in /usr/lib/oracle/client/10.1.2.
The basic package comes with this lot:
[EMAIL PROTECTED] andyh]# rpm --query --list -p
oracle-instantclient-basic-10.1.0.2-1.i386.rpm
/usr/lib/oracle/10.1.0.2/client/lib/classes12.jar
/usr/lib/oracle/10.1.0.2/client/lib/libclntsh.so.10.1
/usr/lib/oracle/10.1.0.2/client/lib/libnnz10.so
/usr/lib/oracle/10.1.0.2/client/lib/libocci.so.10.1
/usr/lib/oracle/10.1.0.2/client/lib/libociei.so
/usr/lib/oracle/10.1.0.2/client/lib/libocijdbc10.so
/usr/lib/oracle/10.1.0.2/client/lib/ojdbc14.jar
No headers so obviously can't compile against just this - have to use a full
Oracle home for that. Compiled DBD-Oracle svn rev. 185. against Oracle
10.1.0.2
Relevant bits of environment:
[EMAIL PROTECTED] DBD-Oracle]# echo $ORACLE_HOME
[EMAIL PROTECTED] DBD-Oracle]# echo $PATH
/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:
/root/bin
[EMAIL PROTECTED] DBD-Oracle]# echo $LD_LIBRARY_PATH
/usr/lib/oracle/10.1.0.2/client/lib
[EMAIL PROTECTED] DBD-Oracle]# echo $NLS_LANG
ENGLISH_UNITED KINGDOM.WE8ISO8859P15
[EMAIL PROTECTED] DBD-Oracle]# echo $ORACLE_USERID
test/test@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=testbox.localhost)(PORT=
1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=dev101)))
So no reference left to the Oracle home - started a fresh session for this
to make sure.
Specified the connect string using the full syntax since it won't know where
tnsnames.ora is.
LD_LIBRARY_PATH pointing to the Instant Client libraries.
[EMAIL PROTECTED] DBD-Oracle]# make test
PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e"
"test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/01base.......ok
t/10general....ORACLE_HOME environment variable not set!
t/10general....ok
t/20select.....ORACLE_HOME environment variable not set!
t/20select.....ok
t/21nchar......NLS_LANG=ENGLISH_UNITED KINGDOM.WE8ISO8859P15
ORACLE_HOME environment variable not set!
NLS_CHARACTERSET=WE8ISO8859P15
NLS_NCHAR_CHARACTERSET=UTF8
t/21nchar......ok
t/25plsql......ORACLE_HOME environment variable not set!
t/25plsql......ok
t/30long.......ORACLE_HOME environment variable not set!
t/30long.......ok
t/40ph_type....ORACLE_HOME environment variable not set!
t/40ph_type....ok 11/19 Placeholder behaviour for ora_type=1 (the default)
varies with Oracle version.
Oracle 7 didn't strip trailing spaces, Oracle 8 did, until 9.2.x
Your system doesn't. If that seems odd, let us know.
t/40ph_type....ok
t/50cursor.....ORACLE_HOME environment variable not set!
t/50cursor.....ok
t/60reauth.....skipped
all skipped: no reason given
t/70meta.......ORACLE_HOME environment variable not set!
t/70meta.......ok
All tests successful, 1 test skipped.
Files=10, Tests=1554, 43 wallclock secs ( 7.29 cusr + 0.95 csys = 8.24
CPU)
So it whinges a bit about ORACLE_HOME not being set, but works.
--
Andy Hassall <[EMAIL PROTECTED]> / Space: disk usage analysis tool
<http://www.andyh.co.uk> / <http://www.andyhsoftware.co.uk/space>