I try to pass to use Sql dynamic to select rows from a table appearing with the same name in many schemas:
mystring:='schema';
mydynamic='select data from :1.table';
execute immediate mydynamic using mystring into mydata;

I get the following error "Invalid table name"
What's wrong? I use Oracle 10g.