Reg use of Tablefunctions

[Former Member]

Hi guys,

I need the elaborated procedure for JDBC to JDBC with Table functions scenario.Please help me.

Thanks in Advance,

Devika

[bhavesh_kantilal]

Well here is another link, but one I hope does help!

Regards,

Bhavesh

[dharamveer_gaur2]

use blog for JDBC To JDBC scenario

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/xi/jdbc%2bto%2bjdbc

use for JDBC reciever Structure http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/frameset.htm

reciever adapter parameter

username:<Oracle System user>

Password:Login password of oracle

driver : oracle.jdbc.driver.OracleDriver

url:jdbc:oracle:thin:@<serverhostname>:1521:<SID>

SID is Oracle server database name.

Check always serialable property.

Edited by: Dharamveer Gaur on Sep 18, 2008 1:03 PM

[Former Member]

Hi

please check the bleow mentioned links :

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/xi/jdbcTOJDBC

https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/wlg/3928-- [original link is broken] [original link is broken] [original link is broken] JDBC Receiver Adapter -- Synchronous Select u2013 Step by Step

---File to JDBC

https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/wlg/2590--good [original link is broken] [original link is broken] [original link is broken] one

the driver details :

Driver: com.sap.portals.jdbc.oracle.OracleDriver

- URL: jdbc:sap:oracle://<server>:<port>;SID=<sid> e.g.

jdbc:sap:oracle://myoracleserver:1521;sid=PIL

Regard's

Chetan Ahuja