+21 Sep 2004 Kevin Rosenberg <kevin@rosenberg.net>
+ * doc/appendix.xml: Add note about loading Oracle8 version
+ * db-oracle/oracle-loader.lisp: Support Oracle8 based on
+ data from David Young.
+
10 Sep 2004 Kevin Rosenberg <kevin@rosenberg.net>
* doc/Makefile, doc/catalog-darwin.xml: Apply
patch from Cyrus Harmon for building docs on Mac OS X
(in-package #:clsql-oracle)
-(defparameter *oracle-lib-path*
+(defparameter *oracle-home*
(let ((oracle-home (getenv "ORACLE_HOME")))
(when oracle-home
- (make-pathname :directory
- (append
- (pathname-directory
- (parse-namestring (concatenate 'string oracle-home "/")))
- (list "lib"))))))
+ (parse-namestring (concatenate 'string oracle-home "/"))))
+ "Pathname of ORACLE_HOME as set in user environment.")
(defparameter *oracle-client-library-path*
(uffi:find-foreign-library
- "libclntsh"
- `(,@(when *load-truename* (list (make-pathname :directory (pathname-directory *load-truename*))))
- ,@(when *oracle-lib-path* (list *oracle-lib-path*))
- "/usr/lib/oracle/10.1.0.2/client/lib/")
+ '("libclntsh" "oci")
+ `(,@(when *load-truename*
+ (list (make-pathname
+ :directory (pathname-directory *load-truename*))))
+ ,@(when *oracle-home*
+ (list
+ (make-pathname :defaults *oracle-home*
+ :directory
+ (append (pathname-directory *oracle-home*)
+ (list "lib")))
+ (make-pathname :defaults *oracle-home*
+ :directory
+ (append (pathname-directory *oracle-home*)
+ (list "bin")))))
+ "/usr/lib/oracle/10.1.0.2/client/lib/")
:drive-letters '("C")))
(defvar *oracle-supporting-libraries* '("c")
library. (<filename>libclntsh.so</filename>). The location of
this library is specified relative to the
<symbol>ORACLE_HOME</symbol> 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.
+ environment.
+ </para>
+ </sect2>
+ <sect2>
+ <title>Library Versions</title>
+ <para>
+ &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
+ <symbol>:oci7</symbol> onto <symbol>cl:*features*</symbol>
+ prior to loading the <filename>clsql-oracle</filename> &asdf;
+ system.
+ <screen>
+ (push :oci7 cl:*features*)
+ (asdf:operate 'asdf:load-op 'clsql-oracle)
+ </screen>
</para>
</sect2>
<sect2>