Qore Oracle Module Oracle Module for Qore Programming Language
Download

Qore Oracle Module Ranking & Summary

Qore Oracle Module Tags

module Oracle programming language Oracle module Qore Qore Oracle

Qore Oracle Module Description

Oracle Module for Qore Programming Language Qore Oracle Module is an Oracle DBI driver module for the Qore programming language. The Oracle driver is aware of different character-encodings and supports multithreading, transaction management, stored prodedure and function execution, and more.Qore Oracle Module 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 valuesThe driver's name is "oracle" and the Datasource type constant is SQL::DSOracleex: $db = new Datasource(DSOracle);ex: $db = new Datasource("oracle");Documentation in docs/oracle-module-doc.htmltest/example script: test/db-test.qBUILD AND INSTALLIf 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)configuremakesudo make installThe configure script will find out where your qore module directory is found and set this for the install directory.BUILD FROM SVNreconf.shconfiguremakesudo make install Requirements: · Qore Programming Language

Qore Oracle Module Related Software