>1. If I store an image(.bmp,.gif,etc) in the BLOB and nothing in the CLOB, I receive the error 'ORA-24801 illegal parameter value in OCI lob function'.
How are you "store"ing it? Is the CLOB
>2. If in the above case I load space(s) or character values in the CLOB, the initial insert into Oracle works, however, subsequent updates of the same record produce the error 'ORA-00932 inconsistent datatypes'.
How are you updating..Are you using UPDATECLOB
>In my tests so far, I have found that if I load text information into the CLOB and leave the BLOB empty, initial and repeated updates work fine. The BLOB and CLOB fields are setup as memo fields in the view. Also, if the update property of the field not being used is set to .f.(dbsetprop), the updates work fine for the field that does contain a value.
Are you using ODBC?
I guess what I'm saying is I don't know can you post some code?
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only