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 " .