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.