Home » Developer & Programmer » Reports & Discoverer » refcursor query that returns different refcursor types
refcursor query that returns different refcursor types [message #234152] Mon, 30 April 2007 04:09 Go to next message
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 Go to previous messageGo to next message
ritikaindu
Messages: 30
Registered: March 2007
Location: asas
Member

please send some solution .Its urgent
Re: refcursor query that returns different refcursor types [message #234882 is a reply to message #234783] Thu, 03 May 2007 07:00 Go to previous messageGo to next message
ab_trivedi
Messages: 460
Registered: August 2006
Location: Pune, India
Senior Member
hi Ritika,
please explain your problem in detail.
Ashu
Re: refcursor query that returns different refcursor types [message #235112 is a reply to message #234882] Fri, 04 May 2007 01:58 Go to previous messageGo to next message
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
Re: refcursor query that returns different refcursor types [message #235801 is a reply to message #235112] Tue, 08 May 2007 01:13 Go to previous messageGo to next message
ritikaindu
Messages: 30
Registered: March 2007
Location: asas
Member

is there any solution or should i make separate reports?
Re: refcursor query that returns different refcursor types [message #235896 is a reply to message #235801] Tue, 08 May 2007 05:42 Go to previous messageGo to next message
skooman
Messages: 912
Registered: March 2005
Location: Netherlands
Senior Member
Have no experience with this, but purely based on the documentation this can not be done:

"Oracle Reports supports only strongly typed REF CURSORs."
see http://www.oracle.com/webapps/online-help/reports/10.1.2/state/content/navId.3/navSetId._/vtTopicFile.htmlhelp_rwbuild_hs%7Crwwhthow% 7Cwhatare%7Cdmobj%7Csq_a_refcu~htm/
Re: refcursor query that returns different refcursor types [message #235898 is a reply to message #235896] Tue, 08 May 2007 05:48 Go to previous message
ritikaindu
Messages: 30
Registered: March 2007
Location: asas
Member

ok.thanks for reply.
Ritika
Previous Topic: Help in check printing
Next Topic: Oracle reports builder
Goto Forum:
  


Current Time: Thu Dec 08 04:09:43 CST 2016

Total time taken to generate the page: 0.06587 seconds