DECLARE
s VARCHAR2 (32767);
BEGIN
s := s || q’[ order by regexp_substr(cc.contnum, ‘[[:alpha:]]+’)
, to_number(regexp_substr(cc.contnum, ‘(\d)+’, 1, 1))
, to_number(regexp_substr(cc.contnum, ‘(\d)+’, 1, 2))]’;
END;
/
This is a bug in the data access component version used in Toad 13. I’ve opened a support ticket with them.
In the meantime as a workaround you can choose chars other than square brackets for your Q-Quote. Example, q’<…>’ works with your sample.
Michael
This is fixed in the next beta.