Dear colleges,
I read BLOBs from oracle database and write these in a loop to a the file
system.
Some documents (e.g.PDF) are not correct and I can't open these.
Database size of these blobs is different to size on the file system.
Which code I should use for readig blob from oracle database?
Need I to use chunks?
Where is the problem please?
MY CODE:
------------------------------------------------
sys.dbc = cx_Oracle.connect("user/passw...@db")
sys.csr.execute('SELECT blob FROM BLOB_TABLE')
aSQLData = sys.csr.fetchone()
aLob = aSQLData[0]
aLobData = aLob.read() #this is type str
f = open ("c:\\tmp\\test.pdf","wb" )
f.write(aLobData)
f.close()
------------------------------------------------
Thank you very much for every idea.
Best regards
Mark
--
GRATIS für alle GMX-Mitglieder: Die maxdome Movie-FLAT!
Jetzt freischalten unter http://portal.gmx.net/de/go/maxdome01
--
http://mail.python.org/mailman/listinfo/python-list
