cx_Oracle(Eclipse)not image found but works well in command line

In eclipse, set the following ‘environment variables’ under ‘PyDev’, Interpreter – Python (or which ever you are using).

1. ORACLE_HOME=[your installation path]/instantclient_10_2
2. LD_LIBRARY_PATH=$ORACLE_HOME
3. DYLD_LIBRARY_PATH=$ORACLE_HOME

It worked for me.

OR

• ORACLE_HOME=/WorkSpace/oracle/instantclient11.2
• LD_LIBRARY_PATH=/WorkSpace/oracle/instantclient11.2
• DYLD_LIBRARY_PATH=/WorkSpace/oracle/instantclient11.2
  
• ORACLE_HOME=[your installation path]/instantclient_10_2
• LD_LIBRARY_PATH=$ORACLE_HOME
• DYLD_LIBRARY_PATH=$ORACLE_HOME
• 
  
  
  
  
  最后终结方法：
  如果报错：Library not loaded: /ade/b/2649109290/oracle/rdbms/lib/libclntsh.dylib.11.1
  则 mkdir /ade/b/2649109290/oracle/rdbms/lib并且cp一份libclntsh.dylib.11.1到这个目录下
  如果报错：Library not loaded: /ade/b/2649109290/oracle/rdbms/lib/libnnz11.dylib
  则 mkdir /ade/b/2649109290/oracle/ldap/lib并且cp一份libnnz11.dylib到这个目录下