- Mark as New
- Follow
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report
I'm using JDBC service Execute sql statement.
I will explain with simple code:
insert into mytable (id, desc) values (1, 'this is Client document');
This works perfect.
But if I have single quotes in the desc -
insert into mytable (id, desc) values (1, 'this is Client's document');
It's throwing error to stalled operation errors.
I know that in Oracle, to escape single quotes we write
insert into mytable (id, desc) values (1, 'this is Client''s document');
But, we cant control here in Adobe as the desc is coming from a form's field where the user enters it.
I'm guessing this could be a known problem & can anyone tell me the solution.
Thanks,
kc
Solved! Go to Solution.
Views
Replies
0 Likes
Total Likes