Qore Programming Language

The oracle module provides a database driver for Oracle databases.  The current version is 2.0.

Requires qore 0.7.0 and oracle 9i+ headers and libraries to build (also works with the Oracle instant client); however Qore 0.8.1 is required for SQLStatement support (prepare statement API).

module documentation: http://qore.org/manual/modules/oracle/oracle-module-doc.html

RPMs for Linux can be found at the opensuse build service here: http://download.opensuse.org/repositories/devel:/languages:/misc/

Mac OS/X users can install this module by using macports by issuing the following command

sudo port selfupdate
sudo port -vu install qore-oracle-module

The portfile can be found here: http://trac.macports.org/browser/trunk/dports/lang/qore-oracle-module/Portfile

The "oracle" DBI driver is stable and has been extensively tested (it gets hammered daily handling GB of data in production use).

• 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
• binding and retrieving oracle named types and collections is supported
• Qore's prepared statement API (the SQLStatement class) is supported when the module is compiled against qore 0.8.1 or better

The driver's name is "oracle" and the Datasource type constant is SQL::DSOracle
ex:

my Datasource $db(DSOracle);
my Datasource $db("oracle");