Toad for Oracle 13.0 doesn't accept the code below and returns error "ORA-01756: quoted string not properly terminated"
declare
l_sql varchar2(32767);
begin
l_sql := q'[
select regexp_replace(v.instrument_code, '[0-9]{8}', v.src_sys_trade_id) as new_instrument_code
from tmp$instrument v
]';
end;
/
The code is fine .
