Toad World® Forums

Can't compile PL/SQL block 13.0.0.64


#1

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;
/


#2

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


#3

This is fixed in the next beta.