Compiling a procedure that hasa WITH clause, will result in a syntax error.
Example of error:
ERROR line 4, col 10, ending_line 4, ending_col 12, Found <>, Expecting: @ string or ( or % . [ or (+) AT DAY YEAR or ** MULTISET or * / MOD REM or + - || or ; USING
This occurs in both the Schema Browser and Editor window when compiling. Making modifications to the procedure that still includes the WITH clauseand compiling to the database will result in an error also.
WORKAROUND:
Compile with Alter statement via Toads Editor or SQL*Plus.
In the Toad Editor,usethe following syntax:
>>?ALTER PROCEDURE?????????????procedure COMPILE???????????????>
??schema.?? ??DEBUG??
Example
ALTER PROCEDURE TOADUSER.loopproc COMPILE;
Click on the Execute as script (lightening bolt) icon.
STATUS:
This issue is fixed in Toad for Oracle 9.6. This version can be downloaded at https://support.quest.com/SUPPORT/index?page=downloads.
The error occurs in version 9.5 only.
