Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Query to be executed at Syn JDBC Receiver

Dear Freinds,

I am facing with this issue, i am passing a Native SQL Query as string from Syn Proxy to Syn JDBC with a key field as place holder.

As per my understanding place holder field should have the same as the once used in Native SQL Query. In the query its prefixed & suffixed with $. Correct ?

Also in the action field i have put SQL_QUERY correct ?

I am passing a Select Query (join query). In the query i have same conversion functions for date manipulations which comes within ' ' (single quotes). This quotes changes to '

What could be the problem. In the Communication channel under Processing tab in SQL Syntax parameters (Escape symbol for apostrophe) what should be given ?

Based on the execution of the Select query some fields are fetcehd from Oracle table. This will be response message from JDBC to Proxy.

But i am getting error as '' Invalid SQL stmt" . What could be the problem. How to rectify.

Please give me soultion for the above questions.

Thanks & Regards

K.Ramesh

Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question