I am trying to create a stored procedure to revoke/grant permissions
on table names output from a simple select.
I can't seem to use execute immediate or declare/prepare/execute
statement within the procedure - all fail with "compile" errors.
Can someone assist?