The Oracle back-end requires the Oracle OCI client library. (libclntsh.so). The location of this library is specified relative to the ORACLE_HOME value in the operating system environment.
CLSQL has tested sucessfully using the client library from Oracle 9i and Oracle 10g server installations as well as Oracle's 10g Instant Client library. For Oracle 8 and earlier versions, there is vestigial support by pushing the symbol :oci7 onto cl:*features* prior to loading the clsql-oracle ASDF system.
(push :oci7 cl:*features*) (asdf:operate 'asdf:load-op 'clsql-oracle)
Use
(asdf:operate 'asdf:load-op 'clsql-oracle)
to load the Oracle back-end. The database type for the Oracle back-end is :oracle.
The userenv operator is Oracle specific.
Oracle does not support the except operator. Use minus instead.
Oracle does not support the all, some, any subquery operations.
By default, CLSQL starts in transaction AUTOCOMMIT mode (see set-autocommit). To begin a transaction in autocommit mode, start-transaction has to be called explicitly.