The Oracle back-end requires the Oracle OCI client library. ( The location of this library is specified relative to the ORACLE_HOME value in the operating system environment.

Library Versions

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)



(asdf:operate 'asdf:load-op 'clsql-oracle)

to load the Oracle back-end. The database type for the Oracle back-end is :oracle.

Connection Specification

Syntax of connection-spec

(global-name user password)

Description of connection-spec


String representing the global name of the Oracle database. This is looked up through the tnsnames.ora file.


String representing the user name to use for authentication.


String representing the password to use for authentication..


Symbolic SQL Syntax

  • 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.