[Zope] DCOracle data types

paulabrams@yahoo.com paulabrams@yahoo.com
Fri, 09 Jul 1999 15:49:56 -0700


Hello,

I need to store a large amount of textual data in oracle 8 using a zsql
method. I used type BLOB for the column, but when I try to save to I
get the error message "oci.error ... Invalid type code, 113, for column
7"

Column 7 is type BLOB in the oracle database, but in my SZQL method I
try to update that field with "<!--#sqlvar body type=string-->". 

 - Does Zope know how to handle BLOBs? 
 - Should I be using a different SZQL type than "string"? 
 - Is there is a different data type I should be using in the database?

Thanks in advance,
-Paul