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.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center