Compilation of code with LOG ERRORS clause is causing the following syntax error to pop up in the Toad Editor but SQL PLUS compiles fine.
[Error] Syntax check (12:38)
ERROR line 12, col 38, ending_line 12, ending_col 40, Found LOG, Expecting: ( SELECT -or- INTO WITH
Example of a package that can cause the error in Toad but not in SQL PLUS is as follow.
CREATE OR REPLACE PACKAGE TEST_PACKAGE IS
PROCEDURE TEST_PROCEDURE;
END;
/
CREATE OR REPLACE PACKAGE BODY TEST_PACKAGE IS
--
-- The multi-table insert without error logging from before
PROCEDURE TEST_PROCEDURE
AS
BEGIN
INSERT ALL
INTO TABLE_A VALUES (COL1_VALUE)
INTO TABLE_B VALUES (COL1_VALUE)
SELECT 1 COL1_VALUE FROM DUAL;
--
-- The multi-table insert with error logging from before. But in a
-- Toad believes this is a syntax error.
INSERT ALL
INTO TABLE_A VALUES (COL1_VALUE) LOG ERRORS INTO TABLE_A_ERRLOG
INTO TABLE_B VALUES (COL1_VALUE) LOG ERRORS INTO TABLE_B_ERRLOG
SELECT 2 COL1_VALUE FROM DUAL;
--
END;
END;
/
Issue in QP5.dll
WORKAROUND
None
STATUS
Waiting for fix in a future release of Toad for Oracle.
