Can JDBC adapter be scheduled to call stored procedures

[Former Member]

Can JDBC adapter be scheduled to call stored procedure in other database passing previous date as input parameter

[Former Member · Accepted solution]

Hi

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

Check the above mentione blog

Regards

krishna

Note:reward points if useful

[Former Member]

ok

[bhavesh_kantilal]

Yes you can call Stored Procedures using the JDBC receiver adapter.

Regards

Bhavesh

[Former Member]

Hi Gurus,

actually our scenario is jdbc->XI( <-RFC->)->File

Here our payload is around 5000 records

can it be advisable to use rfc synchronous communication.

The scenario will be exected only in night times.so can we schedule the adapter as we are using sp9.

If not what must be the good design approach.

And also after scheduling to a perticular period ,if there is any down time of XI server,will the process start immediately after the sever up or it will again watch for that perticular time.

[Former Member]

hello,

Can u plz elaborate u r requirement?