[cx-oracletools-users] CLOBs and BLOBs for DataDump.py?

[Michael M. <mm...@gm...>]

First off, things are going MUCH better with this whole tool set..
once I got my head out of my keister..

:)

Anyway, can DataDump.py capture columns (and rows) with CLOBs and BLOBs types?

When we attempt the 'dump' this error pops up in the log:

(05:27:03 PM) ke...@tr...: 17:49:29.603     Details:
17:49:29.603         Exception type: Cannot convert <cx_Oracle.LOB
object at 0xb7d5c968> to an Oracle constant representation.
17:49:29.603         Local Variables:
17:49:29.603         file
/usr/lib/python2.5/site-packages/cx_OracleUtils.py, line 85, in
GetConstantRepr
17:49:29.603           value -> <cx_Oracle.LOB object at 0xb7d5c968>
17:49:29.603         file DumpData.py, line 48, in <module>
17:49:29.603           connection -> <cx_OracleEx.Connection to USER@HOST>
17:49:29.603           cursor -> <cx_OracleEx.Cursor on
<cx_OracleEx.Connection to USER@HOST>>
17:49:29.603           cx_LoggingOptions -> <module
'cx_LoggingOptions' from
'/usr/lib/python2.5/site-packages/cx_LoggingOptions.pyc'>
17:49:29.603           cx_OptionParser -> <module 'cx_OptionParser'
from '/usr/lib/python2.5/site-packages/cx_OptionParser.pyc'>
17:49:29.603           cx_OracleUtils -> <module 'cx_OracleUtils' from
'/usr/lib/python2.5/site-packages/cx_OracleUtils.pyc'>
17:49:29.603           datetime -> <module 'datetime' from
'/usr/lib/python2.5/lib-dynload/datetime.so'>
17:49:29.603           description -> [('RULE_NAM', <type
'cx_Oracle.STRING'>, 40, 40, 0, 0, 0), ('RULE_TXT', <type
'cx_Oracle.CLOB'>, -1, 4000, 0, 0, 1), ('COMPILED_RULE', <type
'cx_Oracle.BLOB'>, -1, 4000, 0, 0, 1), ('COMPILED_RULE_TYP_CDE_KEY',
<type 'cx_Oracle.NUMBER'>, 17, 22, 16, 0, 1), ('DATA_CREATOR_NAM',
<type 'cx_Oracle.STRING'>, 20, 20, 0, 0, 0), ('DATA_CREATED_TSTMP',
<type 'datetime.datetime'>, 23, 7, 0, 0, 0), ('DATA_MODIFIER_NAM',
<type 'cx_Oracle.STRING'>, 20, 20, 0, 0, 0), ('DATA_MODIFIED_TSTMP',
<type 'datetime....
17:49:29.603           format -> 'insert into %s (\n  %s\n) values (\n
 %s\n);\n'
17:49:29.603           i -> 1
17:49:29.603           names -> ['RULE_NAM', 'RULE_TXT']
17:49:29.603           options -> <Values at 0xb6b8ae8c:
{'showBanner': None, 'help': None, 'logLevel': 'debug', 'sourceQuery':
None, 'traceback': None, 'tableName': 'ODS_DTS.XML_EXPRESSION',
'version': None, 'sortBy': None, 'logPrefix': '%t', 'logFile':
'/tmp/DumpDataLog4.txt', 'schema': 'USER@HOST'}>
17:49:29.603           os -> <module 'os' from '/usr/lib/python2.5/os.pyc'>
17:49:29.603           parser -> <cx_OptionParser.OptionParser
instance at 0xb6b8abec>
17:49:29.603           query -> 'select * from ODS_DTS.XML_EXPRESSION'
17:49:29.603           row -> ('1_TXRULE', <cx_Oracle.LOB object at
0xb7d5c968>, <cx_Oracle.LOB object at 0xb7d5c980>, 293, 'ip601',
datetime.datetime(2007, 6, 27, 0, 0), 'ip601', datetime.datetime(2007,
6, 27, 17, 50, 24), datetime.datetime(2007, 6, 27, 0, 0))17:49:29.603
         sequence -> [0, 1, 2, 3, 4, 5, 6, 7, 8]
17:49:29.603           sys -> <module 'sys' (built-in)>
17:49:29.603           value -> <cx_Oracle.LOB object at 0xb7d5c968>
17:49:29.603           values -> ["'1_TXRULE'"]


-- 
<admiral>

Michael F. March ----- mmarch at gmail dot com
          "Seriously" - HSR