Help in Oracle JDBC Driver and Connection and How to use Store Procedure

[Former Member]

Hi Guru,

I need help in configure the JDBC adapter. My scenario is SAP customized table to legacy Oracle database. Before insert new information into the table, I want to delete the whole table then Insert new set of records into the table.

Currently Setting for Communication Channel as below:

JDBC Driver: oracle.jdbc.driver.OracleDriver

Connection: jdbc:oracle:thin:@hostname:1521:orcl

I do not know how to call Store Procedure in Oracle JDBC.

Anyone who knew and has experienced on this to guide me step by step?

Thanks in advance.

[Former Member]

HI,

Refer the below weblog for writing the stroed procedure.

Receiver JDBC scenario MS access - /people/sameer.shadab/blog/2005/10/24/connecting-to-ms-access-using-receiver-jdbc-adapter-without-dsn

Stored Procedures-

/people/siva.maranani/blog/2005/05/21/jdbc-stored-procedures

http://www.ics.com/support/docs/dx/1.5/tut6.html

/people/sriram.vasudevan3/blog/2005/02/14/calling-stored-procs-in-maxdb-using-sap-xi

http://www.ics.com/support/docs/dx/1.5/tut6.html

http://java.sun.com/docs/books/tutorial/jdbc/basics/sql.html

http://www.sqlteam.com/article/stored-procedures-an-overview

Thnx

Chirag