# Formatting: collate error

**URL:** <https://forums.toadworld.com/t/formatting-collate-error/53603>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [September 7, 2021, 7:48am UTC](https://forums.toadworld.com/t/formatting-collate-error/53603 "2021-09-07T07:48:02Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![peter.daems](https://avatars.discourse-cdn.com/v4/letter/p/c89c15/32.png) [@peter.daems](https://forums.toadworld.com/u/peter.daems)\
**Post date:** [September 7, 2021, 7:48am UTC](https://forums.toadworld.com/t/formatting-collate-error/53603/1 "2021-09-07T07:48:02Z")

</div>

Hi,

The Toad code formatter in Toad for Oracle 13.3 is producing an error when the SQL statement contains COLLATE.

Simple example:  
SELECT \*  
FROM all\_procedures  
WHERE object\_name LIKE '%proc%' COLLATE BINARY\_AI;

De statement runs fine.  
When formatting the code, an error is raised:  
[Error] Syntax check (3: 34): ERROR: line 3, column 34, ending line 3, column 40:  
Found 'COLLATE': Expecting: end-of-input -or- FETCH FOR OFFSET ORDER -or- INTERSECT MINUS UNION -or- CONNECT GROUP HAVING MODEL START -or- OR -or- AND -or- ESCAPE -or- + - | || -or- \* / MOD REMAINDER -or- \*\* -or- ( (+) AT DAY MULTISET YEAR

---

<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:** [September 7, 2021, 9:27am UTC](https://forums.toadworld.com/t/formatting-collate-error/53603/2 "2021-09-07T09:27:12Z")

</div>

Hi Peter,  
FYI The latest formatter for Toad 13.3 was released on Feb 17, 2020 (QP5 v360) and features this error. It was fixed on Feb 5, 2021 (QP5 v364).  
I leave it up to the Toad team to add any suggestions.  
Hope this info can help.  
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:** [September 7, 2021, 12:21pm UTC](https://forums.toadworld.com/t/formatting-collate-error/53603/3 "2021-09-07T12:21:25Z")

</div>

I don't think there is anything you can do to make Toad 13.3 format this statement correctly.

You'll have to update to Toad version 14.2 if you want it fixed. And version 15.0 will be out within the next month or so.

-John
