installing cx_Oracle.

[Carl K]

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.

carl at dell17:~/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