python module cx_Oracle in eclipse: undefined variable from import (ubuntu 10.4)

Question

Hi guys,

so here it is: I'm trying to use the cx_Oracle to access Oracle10g XE database. everything goes ok if i'm invoking python via the shell terminal then use the cx_Oracle module in a command line manner (import, db access and querying). However,I face some problems with Eclipse. There in no comment in the import line where I import the cx_Oracle (suggesting that it knows the path to the module) but any line using methods from the cx_Oracle module is marked with the error "undefined variable from import". i.e. the statement:

dbHndl = cx_Oracle.connect('user/db1@xe') 

yields the err (in the eclipse editor, not in runtime):

undefined variable from import: connect

standard python code works just fine with eclipse.

Any ideas?