Sending Idoc to oracle table Emp usering JDBC Adapter

[Former Member]

Hi Guys,

Can you help me in these when we are pass a message through idoc to Oracle through jdbc adacpter reaciver

what sort of syntax Parameter need to write in

SQLSyntaxParameters Box in ID.

Regd's

Raj

[Former Member]

Hi Raj,

You need to insert data from the IDoc to the Oracle Database. In this case the XML that is being sent to the Receiver JDBC Adapter should be correct.

The format for this can be obtained from the following link:

http://help.sap.com/saphelp_nw2004s/helpdata/en/22/b4d13b633f7748b4d34f3191529946/frameset.htm

Once this is correctly done nothing needs to be mentioned in the SQLSyntaxParameters Box in ID. U can leave the default values as it is.

Regards

Neetu

[Former Member]

Hi Raj,

Please go through the following links...

/people/alessandro.berta/blog/2005/10/04/save-time-with-generalized-jdbc-datatypes

http://help.sap.com/saphelp_nw04/helpdata/en/7e/5df96381ec72468a00815dd80f8b63/content.htm

I hope it helps........

Regards,

Abhy

[Former Member]

Hi,

Please check on the URL to understand the parameters to be used in the adapter.

Also your message structure has to be in the right format for JDBC adapter. You can find the structure details also in the link

http://help.sap.com/saphelp_nw04/helpdata/en/64/ce4e886334ec4ea7c2712e11cc567c/content.htm

Regards

Vijaya