How to call oracle pro*c
can XI call oracle pro*c as sender or receiver?
please guide me.
if not, do i have to persuade users in order to move source to stored procedure?
Bhavesh Kantilal replied
The same problem that comes with an Oracle Stored Procedure exists with an Oracle Function. Both of them return a Cursor , while in the case of a Sender JDBC adapter, it expects a RESULTSET
Oracle Stored Proceudre and Functions acan be called in an JDBC receiver Adapter Only.
As for your customer, well, work arounds are possible. Use a BPM, use a RECEIVER JDBC adapter to execute the STORED PROCEDURE and get the data and then proceed or, just tell them that Oracle Functions and Stored Procedure cannot be used in your scenarios.
If you give your entire requirements, may be some work around can be arrived at.