Skip to main content
I am reading input data stored in Excel format, then making geometry out of it and then writing it to oracle spatial but before writing I have to delete previous records from the tables which I am about to write, the records which I want to delete can be identified from a database field which is there in every table I am about to process.

 

 

Currently I am using SQL Executer alongwith FeatureHolder but in this the query is initiating on each line read. I want something to be executed on process start for one time only.

 

 

Can anybody help me in this.
Hi,

 

 

If you want to execute the query only when the first line comes, you can add sequential number to lines (the Counter), then test whether the line is the first one or not (the Tester).

 

 

Takashi
Maybe this is thinking too simple, but wouldn't the Oracle Writer Mode 'Update' not accomplish exactly this? That is, given the key is set correctly.

Reply