The formatter produces an error when "fetch first xxx rows only" is used with a variable instead of a fixed number:
[Error] Syntax check (9: 53): ERROR: line 9, column 53, ending line 9, column 53: Found ')': Our parser found the following statement to be ambiguous. Please report this to Quest Software Support.
Parser: ORA-SQL-PLSQL, on line: 1, context:
CREATE OR REPLACE PACKAGE BODY FORMATTER_ERROR
IS
PROCEDURE PRODUCE_ERROR
IS
V_LINE_COUNT PLS_INTEGER := 1;
BEGIN
FOR RS IN (SELECT *
FROM DUAL
FETCH FIRST V_LINE_COUNT ROWS ONLY)
LOOP
NULL;
END LOOP;
END PRODUCE_ERROR;
END FORMATTER_ERROR;
/
You may want to COPY this window (Ctrl-C) and then PASTE the content into your report.
You may want to change sensitive fields to say XXXXXX, or remove irrelevant portions of the code.
Thank you!
Just press Enter to continue. Parser may not have done its work correctly but that should be harmless.