Attempting to compile the below dummy procedure using q-operator for quoting strings:
CREATE OR REPLACE PROCEDURE testproc1 AS
v_Str VARCHAR2 (4000);
v_Str := q’| | a ‘Y’ |’;
the procedure cannot be compiled raising error:
“PLS-00103 (6: 22): PLS-00103: Encountered the symbol “Y” when expecting one of the following:”
Same code is created correctly from Toad 12.12 or from Sql*Plus.
If we check the user_source we see that the fourth line has been saved as: " v_Str := ’ a ‘Y’ '; "
(i.e. without the q-operator), and this is the reason of compile error.
Apart the about example, new Toad 220.127.116.11 with q-operator strings cannot handle some greek characters.
New release cannot be used for developments with such issues with q-operator strings.