Skip to Content
0
Former Member
Jan 07, 2010 at 11:25 AM

Sender JDBC Adapter Supports Stored Procedures????

182 Views

Dear All,

I was trying to use the Sender JDBC adapter to call the Stored procedure in the Sender JDBC adapter is possible to do this???

I don't think Sender JDBC Adapter is supported to execute the Oracle Started Procedures. With my understanding only the Receiver JDBC Adapter will supported for the Stored Procedures using the message mapping Action = EXECUTE and Table = DBO.EmployeeMasterTable.

Please let me know how to achieve the below scenario.

My Scenario JDBC to RFC

Query SQL Statement:

select * from dbo.emp where flag = 'Insert' or flag = 'Update' or flag = 'Delete'

Update SQL Statement:

UPDATE dbo.emp SET flag = null WHERE flag IN ('Insert', 'Update');

DELETE dbo.emp WHERE flag = 'Delete';

In the my update statement I need to update few data flag with Insert , Update and need to delete the of the old records as mentioned above the query.

In the response mapping I am using the Action = INSERT and Table = emp.

Thanks,

Jane F.