ORA-00942 with cx_Oracle

I’m trying to run any command on an autonomous database from oracle cloud after establishing connection but they don’t seem to work.

cursor.execute("select * from admin.customers")

gives me the following error

 Traceback (most recent call last):
  File "D:WORKPINGOCPdbConnect.py", line 49, in <module>
    cursor.execute("select * from admin.customers")
    cx_Oracle.DatabaseError: ORA-00942: table or view does not exist

I don’t understand where this error is coming from as I can run the same command in the browser sql developper and it works, also haven’t been able to find any real solution online

The problem might come from me not being on the correct schema but I actually changed it with this :

connection.current_schema = "ADMIN"

Thanks in advance for any leads !

(I am connected as ADMIN through python)

@GMB from the sql dev online I get 2 lines 1 – SH; 2 – ADMIN; and from python I get [(‘SH’,)]

@AnthonyTuininga

connection = cx_Oracle.connect("admin", "password", "db201912040828_medium")

I’m using the db wallet

Answer

Recreated the table and now it works

Thanks all for your comments !

Advertisement

Answer