Stored Procedure in sender JDBC

[Former Member]

Hey all,

I am trying to call a stored procudure in my sender JDBC adapter to send to an Idoc adapter. In the query statement, do I need to give just EXECUTE <stored proc name> or do I need to set up any special setting in the sender adapter?

-Teresa

[bhavesh_kantilal]

Teresa,

Which DB are you trying to access?

If it is an oracle DB, then unfortunately, Sender JDBC adapter does not support stored procedures for an Oracle DB.

Reason is that JDBC adapter expects a RESULTSET while Oracle Stored Procedure returns a Cursor.

For any other DB, EXECUTE <STOREDPROCNAME> will suffice.

Regards,

Bhavesh

[rodrigoalejandro_pertierr]

you said if i want to get data from a oracle db i cannot use an SP, the only way is put in the adapter the sql query?

rgds

RP

[VijayKonam]

Yes. Thats true.

VJ