How to escape special characters?

[bharathi_reddy]

HI team ,

I have short live process which will insert data in to Data base  (oracle 10 G). The process is working fine as per the expectation it is inserting the data in to Data Base  but if we use special characters in the fields the data is not inserting . In Data Base all the variables are of VARCHAR data type. I want to include a piece of code on execute script activity .

for example : In one fields user enter something like this " All features & int'l " .

Please help me how i can achieve this

Thanks in advance

Thanks,

Bharathi