Bill Scherer wrote: > Carl K wrote: >> Getting closer, thanks Bill and Diez. >> >> $ export ORACLE_HOME >> $ ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/client >> $ python setup.py build >> $ sudo python setup.py install >> >> $ python -c "import cx_Oracle" >> Traceback (most recent call last): >> File "<string>", line 1, in ? >> ImportError: libclntsh.so.10.1: cannot open shared object file: No >> such file or directory >> >> guessing I need to add >> /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/lib/ >> to some path? >> > You can `export > LD_LIBRARY_PATH=/usr/lib/oracle/xe/app/oracle/product/10.2.0/client/lib` > > or (assuming a recent RedHat linux (or similar) now), put that path in a > file, /etc/ld.so.conf.d/oracle.conf > > and run /sbin/ldconfig > > You'll find the latter operation to be persistent, and the former is not. >> btw - anyone know of a .deb that will install this? >> >> Carl K >>
bingo. [EMAIL PROTECTED]:~/a/cx_Oracle-4.3.1$ python Python 2.4.4c1 (#2, Oct 11 2006, 21:51:02) [GCC 4.1.2 20060928 (prerelease) (Ubuntu 4.1.1-13ubuntu5)] on linux2 Type "help", "copyright", "credits" or "license" for more information. >>> import cx_Oracle >>> connection = cx_Oracle.connect('testuserA', 'pw', 'nf55') >>> cursor = connection.cursor() >>> cursor.execute("select * from tbl1") [<cx_Oracle.NUMBER with value None>, <cx_Oracle.FIXED_CHAR with value None>, <cx_Oracle.NUMBER with value None>] >>> rows=cursor.fetchall() >>> rows [(1, 'a ', 1.01), (2, 'a ', 1.02), (3, 'a ', 1.03)] Thanks - now I can get to the real problem: client side join/order by :) But I have already done it in MySql, so this should be the easy part... Thanks again. Carl K -- http://mail.python.org/mailman/listinfo/python-list