For
database-type
:oracle
,
connection-spec
conforms to the canonical form described for
connect
in the
LispWorks Reference Manual
. 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.