I’m having difficulties setting a bind variable when running a query not in automation. I’d like to be able to have a query where the database name or the table name is defined by the variable. For example select * from TESTFILE.:Tbl_Name. From there it would prompt me to enter the table name. When I try to do this, it returns the error Token ? was not valid. Valid tokens . I tested the variable in a Where clause such as Where Name = :Name and place the variable and it works fine. Is there no way to set a variable on the database or table name you are selecting?
Thanks so much for any assistance