Describe request like "DESCRIBE
SERVICENAME.TABLENAME" returns the DatabaseError ORA-
00900 "SQL instruction not valid"
I use Python 2.3.4 and cx_Oracle 4.2.1
Logged In: YES
This is not a bug. Only SQL*Plus understands the command
"describe". It is not an actual SQL statement as you'll note
if you go through the SQL reference manual for Oracle. You
can get most of the information you are looking for by
simply performing the following:
cursor.execute("select * from servicename.tablename")
print "Description:", cursor.description
If you want to pretty print it like SQL*Plus does you'll
have to go through the various entries in
cursor.description. Hope that helps.
You seem to have CSS turned off.
Please don't fill out this field.