Question
Accenture
IN
Last activity: 30 May 2016 12:09 EDT
Refcursor within another Refcursor
Hi,
In Our application, we need to access a Ref Cursor within another Refcursor. While we are executing SQL we are getting exception.
example - EmployeeDetails refCursor type -- contains one attribute is EmployeeCertificationDtls (refCursor Type)
Is it possible to access in pega? if possible, how to achieve it? Can you please help us?
we are calling like \{ call StoreProce1({.pyLabel out}, {.pyNote out}, {resultset} \}
Thanks,
Padmanabhan K
Pegasystems Inc.
US
So is the idea here that you want to pass a cursor (result set) into the StoreProce1 procedure via the third parameter?
If so, then I'm afraid that this isn't something we support....
One workaround might be to create a "wrapper" stored procedure to call both the query which produces the result set as well as calling StoreProce1. But depending on what the exact use case is, there might be better ideas.
Accenture
IN
Hi Jamie,
Thanks for the info.
I want to capture the resultset which is coming from the Store Proc. It is a ref cursor which contains again one more ref cursor.
If I want to get it pega, how I can do that?
Pegasystems Inc.
US
I would think about another way to accomplish this--can you combine the two stored procedures in some other way?
I don't think that the product is close to supporting something like this. I'm also not sure that it makes sense for it to; if a customer needs to perform this much specialized processing to combine results from multiple stored procedures, they're probably better of defining this logic inside a "wrapper" stored procedure which is able to return results to PegaRULES in a simpler format (e.g. a single result set).
If you want to provide more information about exactly what the customer is doing, then perhaps we can come up with another idea.
Accenture
IN
Hi Jamie,
Actual Requirement is to display the result like below:
Continuous Learning:
+ Trainings:
+Mandatory Training:
training1
training 2
+Specialized Training:
training 1
training 2
+default Training
training 1
training 2
here Mandatory will be one ref cursor...and inside that trainings will be another Refcursor inside the Trainings.