TOAD for Oracle 16.0.90.1509, Error when formatting code

Toad for Oracle
1

The formatter produces an error when "fetch first xxx rows only" is used with a variable instead of a fix 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.

2

Hi Rainer,

I think your copy of Toad runs with QP5.dll version 5.381 (or lower). This bug has been fixed as of 5.382.

@ John or Michael or Brad, what should be done here?

Hope this helps,
Andre

3

@rainer.koenigs thanks for the report. The new QP5.dll that Andre mentioned is in the Toad beta, so you can either get the beta or wait for next release.

4

The bug does'nt bother me, I just reported it because TOAD itself asked me to do so and because I'm such a good guy :slight_smile: I will wait for the next release, that's no problem. Thanks for always fixing such bugs so fast!

5

Much appreciated! Thank YOU!