Mistery #1
Did you post the exact procedure you are trying to execute?
None of my tools gives syntax error.
Check if you have some "hidden" characters (for example in unix ^M) in your code.

PS: Based on you other PLS-00801 post, try removing all comments from the sql. Also try saving to a file and executing with start {script file}.sql (or @{script file}.sql ).
What is your OS?
.
Last edited by LKBrwn_DBA; 04-23-2009 at 12:36 PM.
Reason: PLS-00801 post...
"The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb