diff sqlpyPlus.py @ 63:16618ff91c63

fixed pull bug
author catherine@cordelia
date Thu, 03 Apr 2008 11:47:08 -0400
parents 833e9d251da3
children 047f82acdc8f
line wrap: on
line diff
--- a/sqlpyPlus.py	Thu Apr 03 11:42:40 2008 -0400
+++ b/sqlpyPlus.py	Thu Apr 03 11:47:08 2008 -0400
@@ -538,13 +538,13 @@
         options, arg = self.pullflags.parse(arg)
         object_type, owner, object_name = self.resolve(arg.strip(self.terminator).upper())
         self.stdout.write("%s %s.%s\n" % (object_type, owner, object_name))
-        self.stdout.write(self.curs.callfunc('DBMS_METADATA.GET_DDL', cx_Oracle.CLOB,
-                                 [object_type, object_name, owner])+'\n')
+        self.stdout.write(str(self.curs.callfunc('DBMS_METADATA.GET_DDL', cx_Oracle.CLOB,
+                                 [object_type, object_name, owner])))
         if options.has_key('full'):
             for dependent_type in ('OBJECT_GRANT', 'CONSTRAINT', 'TRIGGER'):        
                 try:
-                    self.stdout.write(self.curs.callfunc('DBMS_METADATA.GET_DEPENDENT_DDL', cx_Oracle.CLOB,
-                                          [dependent_type, object_name, owner])+'\n')
+                    self.stdout.write(str(self.curs.callfunc('DBMS_METADATA.GET_DEPENDENT_DDL', cx_Oracle.CLOB,
+                                          [dependent_type, object_name, owner])))
                 except cx_Oracle.DatabaseError:
                     pass