The editor incorrectly complains about an error

Toad for Oracle
1

The editor complains about an error with the following PL/SQL snippet, but the code can be compiled without problems.

logger.info(
   UTL_LMS.format_message(c_msg_rows_processed,
                          SQL%ROWCOUNT,
                          TO_CHAR(EXTRACT(hour FROM l_diff), 'FM00'),
                          TO_CHAR(EXTRACT(minute FROM l_diff), 'FM00'),
                          TO_CHAR(EXTRACT(second FROM l_diff), 'FM00'),
                          l_sql_cmd));

Error:

32
Bildschirmfoto 2019-12-10 um 14.07.32.png1076×116 9.78 KB

BR
Dirk

2

Hello Dirk,

What Toad version were you running? Toad 13.2.1.3 does like your code.

Thanks,
Andre

3

Hello,

I' using 13.2.0.258. And "Check for Updates" tells me "This version of Toad is the latest available".

BR
Dirk

4

I've tried the latest Beta (13.3.0.29) and it shows the same error. I was able to strip it down to the following code snippet:

BEGIN
   $IF $$unit_test
   $THEN
   $ELSE
   $END

   UTL_LMS.format_message(c_msg_rows_processed,
                          SQL%ROWCOUNT,
                          TO_CHAR(EXTRACT(hour FROM l_diff), 'FM00'),
                          TO_CHAR(EXTRACT(minute FROM l_diff), 'FM00'),
                          TO_CHAR(EXTRACT(second FROM l_diff), 'FM00'),
                          l_sql_cmd);
END;

As soon as the part with the conditional compilation is deleted, the error disappears.

BR
Dirk

5

It seems this issue is still present in 14.0.15.577. Any plans to fix it in TOAD 14.0?

BR
Dirk

6

Dirk,
Your example snippet with the conditional statement is very useful, it revealed a flaw in the parser. We queued it as QP-3749.

Thanks for reporting this,
Andre