What is the datatype in the view and what is the data type on the Oracle side?


>Thank you for your response.
>But in my case, the field I was tring to update is not a key field.
>
>I can update the table through SQL passthrough
>
>>Qun ---
>>
>>That would occur if you were trying to update a key field where the key is generated by a sequence or stored procedure on the Oracle side.
>>
>>
>>
>>>Hi,
>>>I created a remote view based on an Oracle Database. bt when I tried to update the a field I got a error message saying "Update Conflict".
>>>
>>>Basically, the view is not updatable.
>>>
>>>All the necessary setting has been checked such as writable, send sql update.
>>>
>>>Does anyone have any ideal?
>>>
>>>Qun Shen