Qore Programming Language Files

oracle module for Qore
version 1.0.1 by David Nichols

Requires qore 0.7.1 and oracle 9i+ headers and libraries to build (or instant client - see BUILD AND INSTALL below)

The "oracle" DBI driver is stable and has been extensively tested.
*) transaction management is supported
*) automatic transparent character set conversion is supported when necessary
*) threading support
*) it's possible to call functions and procedures
*) all NUMBER fields are loaded as strings in selects in order to not lose any
   data. Qore would need an arbitrary-precision Number type in order handle
   this case better.
*) it's possible to bind and retrieve *LOB values

The driver's name is "oracle" and the Datasource type constant is SQL::DSOracle
ex: $db = new Datasource(DSOracle);
ex: $db = new Datasource("oracle");

Documentation in docs/oracle-module-doc.html

test/example script: test/db-test.q


BUILD AND INSTALL
-----------------

If you have Oracle 9i or higher or have Oracle Instant Client with development
files included, you can build the oracle module.

Make sure your ORACLE_HOME is set before calling configure (otherwise use the
--with-oracle configure option).  

Header files and libraries must be available in the standard locations.

Oracle Instant Client installation: Make sure the ORACLE_INSTANT_CLIENT
environment variable is set before you run configure (or use the
--with-oracle-instant-client configure option).

Note that on HPUX I have not found a working instant client for 32-bit
PA-RISC, for some reason libnnz10 would not link.

Additionally on HP-UX 11.23 PA-RISC there have been stability and locking
problems with Oracle 10g client libraries; I have not been able to identify
the source.

These problems do not affect any other port and appear to be caused by bugs in
the Oracle client libraries somewhere.

So far I haven't been able to locate the problem.  Use the Oracle driver on
HP-UX PA-RISC with Oracle 10G libraries at your own risk.

Also note that with the instant client distributions (except for oracle 11g
instant client rpms), the libclntsh.sl1.10.* (libclntsh.so.10.*,
libclntsh.dylib.10.*) must be manually symlinked to libclintsh.sl (libclntsh.so,
libclntsh.dylib) in order to link with the included Oracle libraries.

configure options:
--with-oracle=<dir>                 : directory of Oracle installation ("oracle" module)
--with-oracle-instant-client=<dir>  : directory of Oracle Instant Client installation ("oracle" module)

configure
make
sudo make install

The configure script will find out where your qore module directory is found and set this for the install directory.


BUILD FROM SVN
--------------

reconf.sh
configure
make
sudo make install