Hello,
I am using VFP 6.0 SP4 with Oracle 8i(PATCH 8.1.7.3.0) back end. A parameterized remote view is being used to update an Oracle table which contains a BLOB and CLOB field(Binary/Character Large OBject). I have encountered two problems with my tableupdates from Fox:
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'.
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'.
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.
I would appreciate any help that can be offered. Thanks.
Puritanism - The secret fear that someone, somewhere is having fun.