SQL executor working principle

Question

I am using Oracle DB. My sql commands are update commands. I believe it is directly sending to the oracle to execute rather than regular transformer which execute in batches. Please clarify.

nampreetatsafe · Answer

Hi @harish: I just want to clarify that you’re talking about having your Oracle Writer feature type set to Update, and are asking how that is handled? Or are you using a SQLExecutor?

If it’s the Writer that you’re using, than yes it’s making the updates directly through SQL calls to your Oracle database. However, you can set the batch and transaction sizes in the Writer parameters:

SQL executor working principle

1 reply

Reply

Community Stats

Reply

Community Stats

Sign up

An FME Account is required to contribute

Login to the community

An FME Account is required to contribute

Scanning file for viruses.

This file cannot be downloaded