JDBC Stored Procedure. Help required

[Former Member]

Hi All,

Suppose my Stored Procedure name is: getEmpDetails

1. Is this reqest mapping ok:

JDBCEmpReqMt

Statement

getEmpDetails

Execute -

---

action

EmpID

CHAR -

---

type

2. In the JDBC Receiver Adapter

In Connection Parameter : Do we need to give after DatabaseName SelectMethod=cursor or not ?

Regards

[Former Member]

Hi,

If Empid in oracle table is of form Varchar2, i suggest use type = Varchar.

Also since your stored procedure is returning Cursor, you have to use such a Request structure

EmpID

type----

---

VARCHAR

CursorName

isOutput----

---

TRUE

type----

---

CURSOR

Also, from SP16 onwards, you can try out oracle stored procedures returing cursors.

Regards

[Former Member]

Hi Arpil,

I am referring blog

Can you pls see his sample procedure is returning cursor or not? I think so not.

He is using SelectMethod=cursor in Connection parameter of

JDBC receiver adapter. I do not get why?

Regards

[Former Member]

Hi Rick,

I think that's just connection string pertaining to your SQL server. I found this link. http://msdn.microsoft.com/en-us/data/cc325721.aspx#10

Might be helpful.

Also look at this blog for creating structure and mapping.

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/5474f19e-0701-0010-4eaa-97c4f78d...

Tell me if it solves your query.