Reading blobs with MS ADO

[Gaetan Corneau]

Hello,

I have a problem reading data from an Oracle database because some table
store text in blobs. Here is the result o he "desc" command for one of the
offending tables:

Name                            Null?    Type
------------------------------- -------- ----
JOBACTIONID                     NOT NULL NUMBER(10)
JOBID                           NOT NULL NUMBER(10)
COMPINSTSRCNAME                          VARCHAR2(64)
COMPINSTDSTNAME                          VARCHAR2(64)
CLASSSRCNAME                             VARCHAR2(64)
CLASSDSTNAME                             VARCHAR2(64)
JOBSTATUS                       NOT NULL NUMBER(10)
ACTIONTYPE                      NOT NULL NUMBER(10)
JOBACTIONSTART                  NOT NULL DATE
JOBACTIONEND                             DATE
NOTE                                     LONG

The last field, NOTE, has LONG as type, but it is a blob.
When my script tries to access the "Value" property of a blob field, it
crashes:

Traceback (innermost last):
  File "<stdin>", line 1, in ?
  File "d:/PythonScripts/Libs\SCADO.py", line 71, in LoadTableData
    Row[lower(Field.Name)] = Field.Value
  File "d:\apps\Python\win32com\client\dynamic.py", line 394, in __getattr__
    raise pythoncom.com_error, details
pywintypes.com_error: (-2147217887, 'OLE error 0x80040e21', (0, 'Microsoft
OLE DB Provider for ODBC Drivers', 'Errors occurred', None, 0, -2147217887),
None)

Anyone knows how to deal with that?
Thanks,
______________________________________________________
   Gaetan Corneau
   Software Developer (Quality Assurance Team)
   BaaN  Supply Chain Solutions  
   E-mail: Gaetan_Corneau at baan.com        
   Compuserve: Gaetan_Corneau at compuserve.com  
   ICQ Number: 7395494             
   Tel: (418) 266-8252          
______________________________________________________
"Profanity is the one language all programmers know best"