LispWorks User Guide and Reference Manual > 19 Common SQL > 19.2 Initialization


19.2.6 Connecting to Oracle

For database-type :oracle , connection-spec conforms to the canonical form described for connect. The connection part is the string used to establish the connection. When connecting to a local server, it may be the SID, otherwise it is an alias recognized by the names server, or in the tnsnames.ora file.

To connect to Oracle via SQL*Net, connection-spec is of the form username/password@host where host is an Oracle hostname.

Common SQL uses the Oracle Call Interface internally where this is available. For Oracle version 8, Common SQL automatically uses the same API as in LispWorks 4.4. On some platforms, this can also be obtained by using database-type :oracle8 . Note that the :oracle8 database type is restricted because it cannot access or manipulate LOBs and all connections must use the same character set.

LispWorks User Guide and Reference Manual - 22 Dec 2009