Skip to Content (Press Enter)
2017-08-28 11-56-10
Debasis Sahoo
115Views
7Comments
catching a ref cursor output
Question
Hello there,
can anyone tell me the way to catch the recordset returned by ref cursor call. An example will be good.
0
0
14 Jan 2016
Copy Link
2017-08-28 11-56-10
Debasis Sahoo
any suggestions please ?
0
0
12 Feb 2016
Copy Link
2020-09-15 13-07-23
Kilian Hekhuis
 
MVP
Leo,

I don't understand what you mean. Are you talking about Service Studio or Integration Studio?

Tip: when people don't reply, you probably didn't formulate your question in an understandable way.
1
0
12 Feb 2016
Copy Link
2017-08-28 11-56-10
Debasis Sahoo
Hi Killian,
thanks for the reply and i am sorry if i didnt made it clear.
I just want to know if there is any mechanism in service studio by which i can use ref cursor of oracle?
1
0
17 Feb 2016
Copy Link
2020-09-15 13-07-23
Kilian Hekhuis
 
MVP
Hi Leo,

I'm not versed in Oracle, but with Advanced Queries you can send commands to the database (nearly) as-is.
0
0
17 Feb 2016
Copy Link
2017-10-09 13-20-50
Gerrit Bouhuis
Hi Leo,

Did you manage to fetch the records via a stored procedure call?

We're trying to write an extension that we can use to call an Oracle Stored procedure that has 1 output parameter that is defined as SYS_REFCURSOR. The procedure returns a resultset with 0,1 or more rows. Each row has a couple of attributes like an id, a code, a description, a creation date etc. We can't use the Oracle Connector since that is not available for the Java stack. The functionality that we want to use is not supported by Advanced Queries.

Kind regards, Gerrit
1
0
29 Feb 2016
Copy Link
2017-08-28 11-56-10
Debasis Sahoo
Gerrit Bouhuis wrote:
Hi Leo,

Did you manage to fetch the records via a stored procedure call?

We're trying to write an extension that we can use to call an Oracle Stored procedure that has 1 output parameter that is defined as SYS_REFCURSOR. The procedure returns a resultset with 0,1 or more rows. Each row has a couple of attributes like an id, a code, a description, a creation date etc. We can't use the Oracle Connector since that is not available for the Java stack. The functionality that we want to use is not supported by Advanced Queries.

Kind regards, Gerrit
 Hello Gerrit,
we can do this by using oracle connector with input object as a record and output object as a record list.
we have manged to achieve this. sorry for the late reply but i thought it would be worth sharing the success. :)
Output object should bind to OutputList instead of SimpleOutputs
 
0
0
30 May 2016
Copy Link
2017-08-28 11-56-10
Debasis Sahoo
Hello Gerrit,
thanks for the reply. you are correct. Oracle connector lacks this functionality.
I am still finding a way around to get the records. Please let me know when you are done with your code. 
This will help a lot in accomplishing the desired result in an easy way.

0
0
03 Mar 2016
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.