Skip to Content
0
Former Member
Dec 26, 2007 at 10:45 AM

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

29 Views

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.