Toad World® Forums

The editor incorrectly complains about an error

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:

BR
Dirk

Hello Dirk,

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

Thanks,
Andre

Hello,

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

BR
Dirk

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