-(defparameter *clsql-oracle-library-path*
- (uffi:find-foreign-library
- "oracle"
- `(,(make-pathname :directory (pathname-directory *load-truename*))
- "/usr/lib/clsql/"
- "/sw/lib/clsql/"
- "/home/kevin/debian/src/clsql/db-oracle/")
- :drive-letters '("C")))
-
-(defvar *oracle-library-candidate-drive-letters* '("C" "D" "E"))
+(defparameter *oracle-lib-path*
+ (let ((oracle-home (getenv "ORACLE_HOME")))
+ (when oracle-home
+ (make-pathname :directory
+ (append
+ (pathname-directory
+ (parse-namestring (concatenate 'string oracle-home "/")))
+ (list "lib"))))))
+
+(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/")
+ :drive-letters '("C")))