when would you write a stored procedure in sender/receiver jdbc adapter

[Former Member]

Hi Everybody

Can you tell any situation where you would need to write a stored procedure in the query sql statement of sender/ receiver jdbc adapter instead of writing SELECT statement there

why do we need to write stored procedures

thanks and regards,

Anitha

[Former Member]

Hi

Strored procedure will compile only once when its executed first time. In performance basis Stored Procedure will be preferrable.

Thanks

Ramg

[Former Member]

Hi Swetha,

Stored procedures can be used in XI if u want to insert the data into two tables at a time or want to fetch the data from two tables.

U can writhe the stored procedure, import that into XI and in the standard data type for JDBC, use stored procedure name for Table field.

Thanks,

Shabbir.

[Former Member]

Hi Anitha,

why do we need to write stored procedures

Some times a single SQL statement will not suffice for ur transactions....

Say u want to access from 2 tables and update based on some condition..

or nested select statement...

or u want to update a 2 nd table based on the values from 1st table... etc..

In those places it's preferable for going for a Stored Procedure.

The Stored Procedure can be used in both Sender and Receiver JDBC Adapter.

Still nt clarified do post..

Babu