ORA-01756 using Q-quote
Posted: Wed 21 Mar 2018 19:05
Hi there,
Using ODAC 10.1.3.0 with Delphi 10.1.
OraCall.OCIUnicode := True;
Session.Options.UseUnicode := True;
Using TSmartQuery execute the following...
This works well in the previous version of ODAC we used (10.0.x) but no longer works. If I change the Q-quote to be...
...then it works. If the string end delimiter appears in the string followed by a single quote (but not immediately followed) then it's failing incorrectly. If I do not enable the Unicode options then it works as expected.
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
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