using Stored procedure in sender or receiver jdbc adapter

[Former Member]

Hi All,

Please let me know simple blogs for Stored procedure used in sender or receiver jdbc adapter to get data from 2-3 tables

Thanks

[GabrielSagaya]

Please check this blog

/people/jegathees.waran/blog/2007/03/02/oracle-table-functions-and-jdbc-sender-adapter

[Former Member]

Hi

The Stored procedure used in sender Adsapter, Becose Stored Procedure is work as gernal queary for update, delete etc of data base.This work did only sender side , So we used the Jdbc Saender Adapter.

[Former Member]

Hi All,

Please let me know simple blogs for Stored procedure used in sender jdbc adapter to get data from 2-3 tables

Please let me know simple blogs for Stored procedure used in receiver jdbc adapter to insret data to 2-3 tables

[stefan_grube]

you find stored procedure guidelines and examples corresponding to your database with google search.

[Former Member]

Hi

To work with Store proceudres (SP) you have to create the SP's in database like Oracle, Mssql or Msaccess.

Ususally the SP creations are done by database experts. For more info about "SP" try Googling!

The below blog is about SP but not the one you expect!

/people/itisha.alok/blog/2009/03/23/jdbc-stored-procedure-returning-multiple-resultsets

Sender Adapter - -

SP will contain the select Query alone or with it will contain insert, delete statement too.

Receiver:

SP will have insert or delete satement.

Adapter

http://help.sap.com/saphelp_nw04/helpdata/en/2c/181077dd7d6b4ea6a8029b20bf7e55/frameset.htm

The below details are required to configure the adapters

Driver details

database name

Procedure name

user name

password,

Regards

Ramg

[Former Member]

Hi

The Stored procedure used in sender JDBC Adapter.