Toad World® Forums

formatter error


#1

I reported this first in the Beta forum but I found out that the same erro occurs in 5.5.3

The code compiles but when using the formatter I got the following error

11:03:42 Formatter Plus v4.8.7
11:03:42 @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
11:03:42 UNRECOGNIZED CONSTRUCT OR SYNTAX ERROR at LINE 922, COL 22, OFFSET 32374 :
11:03:42 @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
11:03:42 --opcoes
11:03:42 lv_linha_opc := ltbl_opc.FIRST;
11:03:42 <<loop_opcoes>>
11:03:42 LOOP
11:03:42 EXIT WHEN lv_linha_opc IS NULL;
11:03:42 – htp.p(plct_reg_dis);
11:03:42 IF plct_reg_dis MEMBER OF ltbl_opc (lv_linha_opc).regimes
11:03:42 ---------------------^----------------------------
11:03:42 (S76) Expecting: ! != % ( (+) * ** + - .
11:03:42 / < <= <> || = = > >= @ ^ ^= AND AT BETWEEN DAY
11:03:42 IN IS LIKE LIKE2 LIKE4 LIKEC MOD NOT OR REM THEN YEAR
11:03:42 --------------------------------------------------
11:03:42 AND
11:03:42 (plct_ramo MEMBER OF ltbl_opc (lv_linha_opc).ramos)
11:03:42 and ltbl_opc(lv_linha_opc).ano_inf=plct_ano

I think the formatter doesn’t reconizes MEMBER OF as a valid argument


#2

Hi Filipe,

Current Formatter is a third party product, which is not up to date with Oracle syntax.
Formatting in the SQL Nav will catch up with the latest syntax in one of the future releases (6.0 or 6.1), when we will include, as planned, a new formatting tool currently being developed in-house.

Thanks for your input,
Andrew