Solved

Is there a way to run more than one sql query in SQLCreator?

  • 25 February 2020
  • 2 replies
  • 4 views

Badge

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

icon

Best answer by helmoet 25 February 2020, 21:42

View original

2 replies

Badge +8

Use 

FME_SQL_DELIMITER ; 

before all sql. See also discussion on this topic in this article

 

Badge

Use 

FME_SQL_DELIMITER ; 

before all sql. See also discussion on this topic in this article

 

Many thanks, @helmoet!

Reply