Hi,
I have several workbenches which read an FGDB, do a little transforming and renaming, then insert the data in several Oracle tables (one table per fetaureclass, 15 in total). Before the data is written, the tables must be emptied. The trick is that the user is not allowed the privilege to use truncate (if you give an Oracle user the privilege to truncate, that user can also drop tables - which is not allowed).
I have a procedure which allows me to truncate, using a different user, but it looks like I would need to call that procedure 15 times in the "SQL statementto execute before translation", instead of adding it to the format parameters of every featureclass. Is that correct? Not really what I was hoping for, but if it needs to be done it needs to be done :-)