I want to use a Dynamic ORACLE SPATIAL writer in UPDATE MODE.
But when i try to update a row through this, two extra attributes 'ORIENTATION' and 'TEXTSTRING' appends in the query so that when i run the workbench oracle throws an 'invalid identifier' exception and the process stops.
Can anyone tell me how to use a writer dynamically to update a row in oracle spatial database. Thanks in advance.
I suppose the error reason is the lack of these two columns in the table definition. If so, you need to add the columns to the table before updating.
Takashi
I also tried using the same workbench with STATIC Writer. In this case the update works fine.
This problem comes only when i use Dynamic Writer+Schema Mapper.
Due to some restrictions I can't create a new column in my destination. Is there any way around?
what happens if you insert an AttributeExposer with ORIENTATION and TEXTSTRING, followed by an AttributeRemover for these two attributes?
That should prevent these two attributes from ever getting to the writer.
David
I tried your solution but the problem is still the same. I am getting the same error.
I have encoutered this before, in the writer properties you can define attributes to be removed, see general tab>dynamic properties>schema definition>attributes to remove.
Hope this helps.
Thanks for the reply. This Solution works.