Having the following SP:
CREATE OR REPLACE PROCEDURE /*dbo.*/usp_GetChildren
v_ParentLN IN CHAR DEFAULT NULL
OPEN cv_1 FOR
WHERE ParentName = v_ParentLN
AND RcdSts = 'A';
If I want to bring children names based on Parent last name. There could be more than 1 results.
As the SqlPLSQLCommand and the SqlOraPLSQLPrepare is not giving me an option to get back an 'into' list when calling the function, how can I get the info contained in the SYS_REFCURSOR using TD functions ? Thanks in advance !
Anybody from Unify can give some feedback ? thanks
ARBRENES -- Kindly only reply to this forum thread. You started another one earlier and now with this one it is confusing to all of us to have parallel threads. I am putting Brian's info. in this thread because this thread is newer. Here is what he wrote:
He also attached a sample SQL file. Thanks, Brian!!!In the TD 5.2 forum there are a couple of questions regarding result sets from Oracle stored procedures.
This info. is for this topic and duplicate/related topic: https://support.guptatechnologies.com/supportforum/viewtopic.php?f=40&t=7146
There is a very good white paper on this written by Suren Behari, it can be found at
https://samples.tdcommunity.net/samples ... ProcRS.pdf
Basically you need to use the Oracle OLEDb provider.
Further to this, the limitation is that you can only return a predefined number of result sets. i.e. If the number of result sets is dynamic then you are toast. When we came across this limitation we hassled Oracle and were given the attached sql, which I never got around to proving would work, as our oracle project was dropped ( political ), but it looks like it would allow for a dynamic result set list. The limitation of this method, is that all result sets are built before the procedure returns, thus you cannot use this to monitor progress on a long running procedure.
Anyway, you have always been helpful to us, so I hope this helps some of your customers.
I apologize for opening another thread. I am under a very tight corporate delivery deadline and did not get a fast response on my last request on previous post I opened in this forum. I guess I am very frustrated at this point. Sorry.
Who is online
Users browsing this forum: [Ccbot] and 0 guests