# TOAD for Oracle 16.0.90.1509, Error when formatting code

**URL:** <https://forums.toadworld.com/t/toad-for-oracle-16-0-90-1509-error-when-formatting-code/55389>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [June 1, 2022, 7:30am UTC](https://forums.toadworld.com/t/toad-for-oracle-16-0-90-1509-error-when-formatting-code/55389 "2022-06-01T07:30:08Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![rainer.koenigs](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/rainer.koenigs/32/11462_2.png) [@rainer.koenigs](https://forums.toadworld.com/u/rainer.koenigs)\
**Post date:** [June 1, 2022, 7:30am UTC](https://forums.toadworld.com/t/toad-for-oracle-16-0-90-1509-error-when-formatting-code/55389/1 "2022-06-01T07:30:08Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![avergison](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/avergison/32/66_2.png) [@avergison](https://forums.toadworld.com/u/avergison)\
**Post date:** [June 13, 2022, 4:34pm UTC](https://forums.toadworld.com/t/toad-for-oracle-16-0-90-1509-error-when-formatting-code/55389/2 "2022-06-13T16:34:01Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [June 13, 2022, 4:50pm UTC](https://forums.toadworld.com/t/toad-for-oracle-16-0-90-1509-error-when-formatting-code/55389/3 "2022-06-13T16:50:47Z")

</div>

@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.

---

<div class="post-metadata">

**Author:** ![rainer.koenigs](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/rainer.koenigs/32/11462_2.png) [@rainer.koenigs](https://forums.toadworld.com/u/rainer.koenigs)\
**Post date:** [June 14, 2022, 8:30am UTC](https://forums.toadworld.com/t/toad-for-oracle-16-0-90-1509-error-when-formatting-code/55389/4 "2022-06-14T08:30:20Z")

</div>

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 🙂 I will wait for the next release, that's no problem. Thanks for always fixing such bugs so fast!

---

<div class="post-metadata">

**Author:** ![avergison](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/avergison/32/66_2.png) [@avergison](https://forums.toadworld.com/u/avergison)\
**Post date:** [June 14, 2022, 8:46am UTC](https://forums.toadworld.com/t/toad-for-oracle-16-0-90-1509-error-when-formatting-code/55389/5 "2022-06-14T08:46:45Z")

</div>

Much appreciated! Thank YOU!