|Version 5 (modified by 8 years ago) ( diff ),|
SQL Database Access - Oracle
The name of the Oracle driver to be passed to SQL.Databases.Create subprogram is "ORACLE".
Driver's options string is connection string in form username/password@database.
Oracle module requires Oracle 11i (or latter) client installed. Oracle Instant Client is also supported. Automatic configuration facility use ORACLE_HOME environment variable to find where oracle client libraries are. It is possible (and required on OS Windows) to specify path to libraries in the command line of configure (or configure.exe on Windows) program with --with-oracle-libdir switch, for example:
Install Instant Client on OpenSuse
- Download instant client RPMs for your OS, for instance, oracle-instantclient11.2-basic-184.108.40.206.0-1.x86_64.rpm and oracle-instantclient11.2-devel-220.127.116.11.0-1.x86_64.rpm
- Install them using rpm -i oracle-instantclient*.rpm
- Set correct ORACLE_HOME and LD_LIBRARY_PATH environment:
export ORACLE_HOME=/usr/lib/oracle/11.2/client64/ export LD_LIBRARY_PATH=$ORACLE_HOME/lib
Supported data types
Supported League.Values are String, Integers and Float.
Don't use more than 64kbytes of data for Strings.
For integers column use Integer datatype or better Number (18,0).
For floats columns datatype use Binary_Float or Binary_Double. For now Number datatype can be used also, but it changes when Universal_Decimal will be ready.