Hi
Is this possible in Apex
In my SQL query instead of entering the tablespace before each table could I use a substitution as defined under application properties to populate this dynamically?
I have tried adding TABLESPACE in the substitution string and the actual tablespace name in the substitution value and amended the SQL query in an interactive report to be from #TABLESPACE#.mytablename
But I am getting the following error
Query cannot be parsed, please check the syntax of your query. (ORA-00911: invalid character)
What is causing this and what is the recommended solution?
Many Thanks