OraFAQ Forum: Reports & Discoverer » refcursor query that returns different refcursor types

Home » Developer & Programmer » Reports & Discoverer » refcursor query that returns different refcursor types

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

refcursor query that returns different refcursor types [message #234152]

Mon, 30 April 2007 04:09

ritikaindu
Messages: 30
Registered: March 2007
Location: asas

Member

How can we have different return types for a ref cursor query in reports 10g.As reports return only strong refcursors so i am facing this problem.plz suggest some solution.
Ritika

[Updated on: Mon, 30 April 2007 04:14]

Report message to a moderator

Re: refcursor query that returns different refcursor types [message #234783 is a reply to message #234152]

Thu, 03 May 2007 02:54

ritikaindu
Messages: 30
Registered: March 2007
Location: asas

Member

please send some solution .Its urgent

Report message to a moderator

Re: refcursor query that returns different refcursor types [message #234882 is a reply to message #234783]

Thu, 03 May 2007 07:00

ab_trivedi
Messages: 460
Registered: August 2006
Location: Pune, India

Senior Member

hi Ritika,
please explain your problem in detail.
Ashu

Report message to a moderator

Re: refcursor query that returns different refcursor types [message #235112 is a reply to message #234882]

Fri, 04 May 2007 01:58

ritikaindu
Messages: 30
Registered: March 2007
Location: asas

Member

Hi ashu

i am using reports 10g.
In my report i am using refcursor query which uses a function that returns a refcursor which is strong (and not weak).That means it has a fixed number of columns to be returned.
But my situation is like:
on satisfying a certain condition:
open refcursor for c1,c2 from tablename;
else
open refcursor for c1,c2,c3 from tablename;
end if;
Because in above code i need to return different no. of columns
which is not possible,can you give some other method to implement such thing.

Thanks
Ritika

Report message to a moderator