Using ODAC 10.1.3.0 with Delphi 10.1.
OraCall.OCIUnicode := True;
Session.Options.UseUnicode := True;
Using TSmartQuery execute the following...
Code: Select all
DECLARE
s VARCHAR2 (32767);
BEGIN
s := s || q'[Test '[[:alpha:]]+' Test]';
END;
Code: Select all
DECLARE
s VARCHAR2 (32767);
BEGIN
s := s || q'<Test '[[:alpha:]]+' Test>';
END;
I opened a support ticket for this, but then remembered my registered email in the support system is no longer valid so please ignore the support ticket/double post.
Thanks,
Michael