Connecting Tech Pros Worldwide Help | Site Map

Python Connecting to ORACLE problem*** Help me plsss

  #1  
Old June 29th, 2009, 07:08 AM
Member
 
Join Date: Apr 2009
Posts: 36
Hi All,

In my python script i use to run some oracle queries for this i require a library to connect to oracle which is cx_Oracle.

When we were using 9i(oracle).. my script was running fine.. and now when we migrated to 10 G its giving problem...

Few lines of my script

Expand|Select|Wrap|Line Numbers
  1. import sys
  2. import cx_Oracle
  3. from datetime import date, timedelta
  4. import mail
  5. import time
when above code runs its throwing error as ...

Expand|Select|Wrap|Line Numbers
  1.    import cx_Oracle
  2. ImportError: ld.so.1: python: fatal: libclntsh.so.9.0: open failed: No such fil\
  3. e or directory
if you see above error is clearly looking old 9i library .. as of now we are in 10 g

And my question is

How do I tell Python which Oracle Home to use?
Reply