User bio

15+ experience with InterSystems products, in different sizes of projects, different countries, and different fields except for healthcare.

Dubai, UAE
Member since Dec 4, 2015
Pinned posts:

The best and most correct solution would be to use parameters in SQL and pass a value as a parameter

INSERT INTO MyText
    (text)
VALUES
    (?)

While you have Oracle somewhere behind, Oracle should support parameters as well, but I don't know how it will work in this case

The increase may appear due to passing this query to the next database, and it escaped again. Passing as parameters may solve this issue.

But still even without this apostrophe the string is too long

Open Exchange applications:
Certifications & Credly badges:
Global Masters badges:
Followers:
Following:
Dmitry has not followed anybody yet.