How to execute two instructions (creating a temporary table and a stored procedure) in the tool WSO2 Data Services Server (DS)?
I need to create a temporary table and then use it in a stored procedure. This would require running the two instructions in a single session with the database, otherwise the temporary table would not be visible. I tried to create the query, inform both options eg create table x; usp_y exec did not work. Is there another possibility?
How to execute two instructions (creating a temporary table and a stored procedure) in the tool WSO2 Data Services Server (DS)?
===

I need to create a temporary table and then use it in a stored procedure. This would require running the two instructions in a single session with the database, otherwise the temporary table would not be visible. I tried to create the query, inform both options eg create table x; usp_y exec did not work. Is there another possibility?