on 09-27-2006 10:43 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
10 | |
9 | |
8 | |
6 | |
6 | |
6 | |
5 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.