Originally posted by stmontgo
how was the select access granted? through a role?

drt needs to explicitly grant you select on the route table, this is expected behavior
But in this case he should have gotten the same "ORA-00942: Table or view does not exist" error when running the anonymous block!

I don't belive the user that is running the anonymous block and the schema under which the procedure is created are actually the same in this case.