reserved words in quoted strings messes up code highlighter

103 views
Skip to first unread message

Captain Packers

unread,
Sep 26, 2017, 11:59:16 AM9/26/17
to TiddlyWiki
I'm running into a situation where I'm using reserved words withing quoted strings for output messages in PL/SQL, and the reserved words are messing up the syntax highlighting.

For example:

dbms_output.put_line('update_stf03_academicyear: commit not executed');

has this affect on the rest of the code block:

    if j = 0 then
      if G_COMMIT then commit; end if;
      dbms_output.put_line('updatestf03: ' || i || ' records ' ||
        'updated with academicyear');
    else
      dbms_output.put_line('updatestf03: WARNING: an ' ||
        'unanticipated result has occurred.');
      dbms_output.put_line('updatestf03: commit not executed');
    end if;

  else 
    dbms_output.put_line('updatestf03: nothing to update');
  end if;

Does anyone know of a work around for this?

Mark S.

unread,
Sep 27, 2017, 9:11:51 PM9/27/17
to TiddlyWiki
I thought it might be that the library needed to be updated. But (assuming I did the upgrade right) it's still broken. So either there's something wrong with the plugin, or there's something wrong with the highlight library.

This might be a small consolation, but you could stop the run-on by putting a comment followed by an apostrophe at the end of the lines where it occurs. Or, since you appear to be just logging, you could break the key words a little (e.g. "com-mit").

Good luck,
Mark
Reply all
Reply to author
Forward
0 new messages