# HG changeset patch
# User catherine@Elli.myhome.westell.com
# Date 1237240134 14400
# Node ID 362db47c17b41a909dee4f8b8d03700e8edb25d8
# Parent  f1916065f95d494271058505842b23ebcdb613ac
error reported

diff -r f1916065f95d -r 362db47c17b4 sqlpython/sqlpython.py
--- a/sqlpython/sqlpython.py	Mon Mar 16 16:24:49 2009 -0400
+++ b/sqlpython/sqlpython.py	Mon Mar 16 17:48:54 2009 -0400
@@ -193,7 +193,32 @@
             command = '%s %s;'
         else:
             command = '%s %s'        
-        self.curs.execute(command % (arg.parsed.command, arg.parsed.args), self.varsUsed)            
+        self.curs.execute('select sysdate from dual')
+        timestamp = self.curs.fetchone()[0]
+        self.orcl.commit()
+        self.curs.execute(command % (arg.parsed.command, arg.parsed.args), self.varsUsed)
+        self.curs.execute('''
+            SELECT ae.owner, ae.name, ae.type, ae.position, ae.line, ae.attribute, 
+                   ae.text error_text,
+                   src.text object_text,
+                   ao.last_ddl_time
+            FROM   all_errors ae
+            JOIN   all_objects ao ON (    ae.owner = ao.owner
+                                      AND ae.name = ao.object_name
+                                      AND ae.type = ao.object_type)
+            JOIN   all_source src ON (    ae.owner = src.owner
+                                      AND ae.name = src.name
+                                      AND ae.type = src.type
+                                      AND ae.line = src.line)
+            WHERE  ao.last_ddl_time >= :timestamp
+            ORDER BY ae.sequence ASC'''
+                          , {'timestamp': timestamp}
+                                       )
+        for err in self.curs:
+            print '%s at line %d of %s %s.%s:' % (err[5], err[4], err[2], err[0], err[1])
+            print err[7]
+            print (' ' * (err[3]-1)) + '^'
+            print err[6]
         print '\nExecuted%s\n' % ((self.curs.rowcount > 0) and ' (%d rows)' % self.curs.rowcount or '')
             
     def do_commit(self, arg=''):