JDBC adapter with multiple table

[Former Member]

Hello Experts,

I whant to practise FILE TO JDBC or SOAP TO JDBC scenario ( simple ) that uses multiple database tables. I have seen posts related to this requirement but i am not able to get the complete idea to execute the scenario.

If it uses stored procedure please give me idea regarding stored procedures. If there are any blogs related to this pelase post the links.

and please give me step by step guide to execute the scenario.

Thanks in advance.

arjun

[Former Member]

Hi

Just create a structure conatining fields to be inserted to DB_Name1 / DB_Name2

below is for oracle.

CREATE OR REPLACE PROCEDURE Storeprocedurename
(
filed1 CHAR,
filed2  CHAR,
filed3  CHAR,
filed4  CHAR,
filed5  CHAR
)
IS
BEGIN

INSERT DB_Table1 ;


INSERT DB_Table2 ;
  

COMMIT;
END StoreProcedurename;
/

rgds

srini

[Former Member]

Use this..

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

Regards,

Sunil.