Syntax for IF inside of WITH structure
Where is the syntax eror in this code. I get “Command not properly ended” on IF iCount statement. Here is the code:Prod_KEY    NUMBER; iCount      NUMBER;                                                                                         BEGIN   WITH TEMP_All AS             (SELECT * FROM TEMP1              UNION ALL              SELECT * FROM TEMP2              UNION ALL              SELECT * FROM TEMP3)                                  SELECT [...]

Answer Question   |  August 14, 2009  10:04 PM
Development, WITH and IF