Python Connecting to ORACLE problem*** Help me plsss

[harshakusam]

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

import sys
import cx_Oracle
from datetime import date, timedelta
import mail
import time

when above code runs its throwing error as ...

   import cx_Oracle
ImportError: ld.so.1: [B]python: fatal: libclntsh.so.9.0[/B]: open failed: No such fil\
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?