Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How to call oracle pro*c

Hi,

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?

thanks

Venjamin(YD)

Former Member
replied

Venjamin,

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.

Regards,

Bhavesh

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question