Sometimes (and only sometimes) if issue an exec command like
I get an ORA-01756 quoted string not properly terminated
copy the failing exec line to sqlplus and it will work so its something in the editor window. Any ideas?
To get it to work in TOAD I remove the exec and wrap a begin end around it (dont edit or touch the proc name)
But just to repeat its only sometimes, I could repeat the same command with exec later on in a TOAD window and it will work.
To further complicate it , when I get the issue, this will work