Executing Select query using JDBC Receiver Adapter

[Former Member]

I created couple types in Oracle and also new function instead of procedure

Can I execute the above query using JDBC Receiver Adapter.

select *

from the ( select cast( apr.get_distribut('', '', '', 'hdfcgd', 'CAN') as dsrTable )

from dual );

If possible how my message structure should look like...

[Former Member]

Hi,

also see JDBC Response /people/swaroopa.vishwanath/blog/2006/12/28/send-rfc-to-sap-xi-150-asynchronous

Regards

Chilla

[Former Member]

Hi vikram,

If you use JDBC as Receiver Adapter you can only post the data to the data base I do no think so we can select the records from the data base.

If you use JDBC as Sender hope,we can the select query in the sender communication channel.

Hope I am clear.

Thanks and Regardds,

Chandu.

[Former Member]

Hi,

use stored procedure to implement this in receiver side.

check, the given sql,works fine or not.

See the below link to get an idea about receiver side JDBC Adapter, and maitain the respective structure.

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

Regards

Chilla