on 11-13-2006 3:11 PM
Hello,
when writing a database entry to an oracle database using the jdbc adapter i get a ORA-00917: missing comma error. I would like to know how I can determine on which field in the structure this error occurs or how I can prevent this from happening.
Best regards,
Jasper
Hi,
Check out document format of the xml message which you are sending to Oracle database. i.e xml message after your mapping.
Is it valid xml ? check out this link-
http://help.sap.com/saphelp_nw2004s/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm
This SAP note may help u- 723149
Regards,
Moorthy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Jasper,
><i>Does it mean that i have to put a 'hasQuot" attribute by every field that expects a quote to be sure that the sql statement is build up the right way ?</i>
yes, for every field that needs a quot, you would need to use Attribute <b>hasQuot</b> with the value <b>YES</b> . By default hasQuot is set to NO.
Regards,
Bhavesh
Hello Moorthy,
thnx for the reply. I checked the help document. Does it mean that i have to put a 'hasQuot" attribute by every field that expects a quote to be sure that the sql statement is build up the right way ?
Best regards,
Jasper
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.