Unable to push the data with single quotes in to oracle database

Help Studio
, ,
1

I am unable to push the single quotes value in to oracle database
ex:PSY’D

The above string while pushing in to database getting error.
I tried of replacing single quotes with double single quotes but no luck.

And also when I have @ at sign also getting failed while pushing in to database when I remove @ sign it is loading successfully.

Both Examples
1)PSY’D
2)KK@gmail.com

To push above what should we do I tried multiple ways but no luck

2

we assume a relationship to

in general we can escape a single quote by another one

PSY'D -> PSY''D

But we should ensure that not the surrounding ’ for eg. a text value is also escaped e.g. by a mass replace

Also you can do RnD by working with the DUAL Table

SELECT 'PSY''D' from dual;
3

I tried but its failing

4

do not ommit to tell what was done what was received

5

Sorry it was working!!!

6

Perfect so we can close the topic
Forum FAQ - How to mark a post as a solution - News / Tutorials - UiPath Community Forum