I am trying to modify an existing workbench which reads features from an Oracle database using an SQLCreator and writes them to a feature class in a geodatabase.
Currently there is a single query in the SQLCreator. I'm trying to add something to the output which requires a temporary table so I now need there to be three queries running in this SQLCreator:
Create temp_table;
Query to extract features from Oracle DB (and temp_table);
Drop temp_table;
Is it possible to run a series of queries in SQLCreator? If not is there some other way? The series of queries work fine when run directly against the database but I cannot get it to work in FME. My fallback is to create views in Oracle rather than using a temporary table but I'd rather not do that if I can avoid it.
Thanks,
Michael
