hello

No more bugs. Right now I'm rewriting the application around simple sql statements, that's why I guess. As for the oracle setup, you did not ask and it's pretty late but maybe the following helps.

I used the instructions that can be found here: http://blog.cachemiss.com/articles/Installing%20Oracle%20XE%20on%20Debian%20... Make sure you download the right files (no large files required) and don't forget to link to the server's tnsnames.ora file.

On my system, things look this way. Good luck and once more thank you.

Regards, chris

~$ uname -a Linux catch22 2.6.32-3-amd64 #1 SMP Wed Feb 24 18:07:42 UTC 2010 x86_64 GNU/Linux (debian)

~$ cat ~/.bashrc

..

export ORACLE_HOME=~/usr/instantclient_10_2 export XE=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server export ORACLE_SID=XE export LD_LIBRARY_PATH=~/lib:/lib:/usr/lib:/usr/local/lib:~/usr/instantclient_10_2:$XE/lib export PATH=~/bin:~/usr/instantclient_10_2:$XE/bin:/usr/local/bin:/usr/local/sbin:/usr/bin:/bin:/usr/sbin:/sbin:/usr/bin/X11:/usr/games   export ORACLE_USERID='chris/woirgend' export ORACLE_DSN='dbi:Oracle:XE' export TNS_ADMIN=~/usr/instantclient_10_2/network/admin

..

chris@catch22:~/usr/instantclient_10_2$ pwd /home/chris/usr/instantclient_10_2

chris@catch22:~/usr/instantclient_10_2$ ls -alsh insgesamt 109M 4,0K drwxr-xr-x  4 chris chris 4,0K  1. Nov 17:27 . 4,0K drwxr-xr-x 25 chris chris 4,0K  1. Nov 18:38 .. 4,0K -rw-r--r--  1 chris chris  228 26. Okt 20:55 BASIC_README 1,6M -r--r--r--  1 chris chris 1,6M 26. Okt 20:55 classes12.jar    0 lrwxrwxrwx  1 chris chris   56  1. Nov 17:27 ctx -> /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ctx/  76K -rwxr-xr-x  1 chris chris  70K 26. Okt 20:55 genezi 4,0K -r--r--r--  1 chris chris 1,5K 26. Okt 20:55 glogin.sql    0 lrwxrwxrwx  1 chris chris   57  1. Nov 17:27 ldap -> /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/ldap/  25M -rwxr-xr-x  1 chris chris  25M 26. Okt 20:55 libclntsh.so.10.1 7,6M -r-xr-xr-x  1 chris chris 7,5M 26. Okt 20:55 libnnz10.so 1,6M -rwxr-xr-x  1 chris chris 1,6M 26. Okt 20:55 libocci.so.10.1  70M -rwxr-xr-x  1 chris chris  70M 26. Okt 20:55 libociei.so 152K -r-xr-xr-x  1 chris chris 147K 26. Okt 20:55 libocijdbc10.so 1,4M -r-xr-xr-x  1 chris chris 1,4M 26. Okt 20:55 libsqlplusic.so 1,3M -r-xr-xr-x  1 chris chris 1,3M 26. Okt 20:55 libsqlplus.so 4,0K -rw-r--r--  1 chris chris  140 26. Okt 20:55 linkora.sh 4,0K lrwxrwxrwx  1 chris chris   78  1. Nov 16:23 listener.ora -> /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/admin/listener.ora 4,0K drwxr-xr-x  3 chris chris 4,0K  1. Nov 17:27 network 1,6M -r--r--r--  1 chris chris 1,5M 26. Okt 20:55 ojdbc14.jar 4,0K drwxr-xr-x  4 chris chris 4,0K 26. Okt 20:55 sdk 4,0K -rw-r-----  1 chris chris 2,2K  1. Nov 16:21 sqlnet.log  12K -r-xr-xr-x  1 chris chris 9,1K 26. Okt 20:55 sqlplus 4,0K -rw-r--r--  1 chris chris  232 26. Okt 20:55 SQLPLUS_README 4,0K lrwxrwxrwx  1 chris chris   78  1. Nov 16:03 tnsnames.ora -> /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/admin/tnsnames.ora

chris@catch22:~$ cat ~/code/lisp-tp/hu-dwim/hu.dwim.rdbms/source/oracle/backend.lisp ;;; -*- mode: Lisp; Syntax: Common-Lisp; -*- ;;; ;;; Copyright (c) 2006 by the authors. ;;; ;;; See LICENCE for details.

(in-package :hu.dwim.rdbms.oracle)

(cffi:define-foreign-library     (oracle-oci :search-path ;               #P"/usr/lib/oracle/xe/app/oracle/product/10.2.0/client/lib/"                 #P"/home/chris/usr/instantclient_10_2/"                 )   (:unix "libocci.so.10.1")   (:windows "libocixe.dll")   (t (:default "libocci"))   )

;;;;;; ;;; Backend API

.. -----Ursprüngliche Nachricht----- Von: Attila Lendvai attila.lendvai@gmail.com Gesendet: Fr 26.11.2010 09:55 An: Marshall McLuhan marshall.mcluhan@gmx.net; CC: cl-rdbms-devel@common-lisp.net; Betreff: Re: [cl-rdbms-devel] hu.dwim.rdbms.oracle-timestamp-with-timezone-local-time-bug

hi!

How do I handle such thing most efficiently? Should I report them at all?

definitely, all bug reports are very welcome!

for the record, i've starred your mail, but i've failed to install oracle in the 2 hours i'm willing to invest into oracle for now.

hopefully others could come up with suggestions, or oracle makes sure that their monster can be installed on a 64bit ubuntu with reasonable effort.