QUESTION Oracle Adapter Custom SQL Configured Operation

I’m having problems inserting data into an oracle db. The insert’s fail due to mal formed sql.
(i.e., if I try inserting the name Fred’s Farm Supplies).

Any know work around. I’ve tried creating a standard INSERT operation, but can’t complete the process due to a time-out. I’ve increased the EI preference time out to 300sec but it just hangs my cpu. I’ve seen some CO’s created using the standard INSERT, but can’t duplicate them myself.

HELP.

THis is because of the data. If the name/data contains '(single quote ) then wM prepare mail formed SQL as follows

Insert into supllier ( name,address) values ( ‘Fred’s’,‘add1’);

so you need to append one more quote whenver a single quote appear in the data .
then the insert query become as follows which would execute smoothly
Insert into supllier ( name,address) values ( ‘Fred’‘s’,‘add1’);

regards

murali

Hi all,
I am in need of a Webmethods specialist with EAI Experience,
can any one help me on this requirement

hi,
For which location is the requirement ? what type of person u are looking for?

Thanks,
shyam