cx_Oracle：我如何获得ORA-xxxxx错误号？

Question

在try/except块中，如何提取Oracle错误编号？

Answer 1

try: 
    cursor.execute("select 1/0 from dual") 
except cx_Oracle.DatabaseError, e: 
    error, = e 
    print "Code:", error.code 
    print "Message:", error.message 

这导致下面的输出：

Code: 1476 
Message: ORA-01476: divisor is equal to zero