The version I am using is 8.1.5. I don't have any groups of arguments as input. I have to retrive a set of rows as cursor(REF CURSOR). But the problem is I could not able to build the cursor directly because I have to pull data from about 16 tables, depending upon some conditions. The pseudo code is
Select features from X, Y, Z tables where bla bla.
loop
For each feature select some subfeatures.
loop
For each subfeature select image, video, etc.. from A, B tables.
fetch the image, videos into some table type variables (arrays)
end loop
end loop
Now I have to build a cursor(record set) with the table type varibles which I already got from above query.
I tried to build the cursor directly by putting so many joins but on performance point of view, I don't want to do that.
Main Topics
Browse All Topics
by: tbcoxPosted on 2001-01-10 at 18:36:04ID: 100576
I don't understand your problem. Your sentence "my schema won't allow to build cursor directly in one fetch" doesn't make any sense to me.
Do you want to pass groups of arguments in?
Do you want to retrieve a set of rows out?
Both?
Have you tried the REF CURSOR type?
What version of Oracle?
-Tom