Skip to content
Advertisement

how to resolve error while using grant admin option in execute immediate

I am trying to run the below script. My script works fine without ‘ WITH ADMIN OPTION’ in EXECUTE IMMEDIATE. But when using ‘ WITH ADMIN OPTION’ i get below error.

“Error report – ORA-00900: invalid SQL statement ORA-06512: at line 17 00900. 00000 – “invalid SQL statement””.

Advertisement

Answer

Try to add a space after grant keyword:

User contributions licensed under: CC BY-SA
1 People found this is helpful
Advertisement