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?