Home » SQL & PL/SQL » SQL & PL/SQL » refcursor not displaying the output
refcursor not displaying the output [message #252841] Fri, 20 July 2007 04:08 Go to next message
ritikaindu
Messages: 30
Registered: March 2007
Location: asas
Member

i have a procedure which returns the result using refcursor OUT parameter.But it is not being displayed when i execute my procedure .If i execute the query alone which is used in returning the resultset,the output is displayed.
where is the problem?

Ritika
Re: refcursor not displaying the output [message #252844 is a reply to message #252841] Fri, 20 July 2007 04:32 Go to previous messageGo to next message
user82
Messages: 49
Registered: June 2006
Location: Romania
Member
I'm not sure that this is a problem...I also use functions which return ref cursors and also when a try select <function> from dual is does not display the result...but in my application i can get the correct result set so this is enough for me...Why do you need to get the result set by executing the procedure?, for tesitng try to get the SELECT statement the creates the cursor (if using dynamic SQL)
Re: refcursor not displaying the output [message #252857 is a reply to message #252844] Fri, 20 July 2007 07:13 Go to previous messageGo to next message
ritikaindu
Messages: 30
Registered: March 2007
Location: asas
Member

but my application is not showing any result.Now where is the problem

Ritika
Re: refcursor not displaying the output [message #252875 is a reply to message #252857] Fri, 20 July 2007 08:08 Go to previous messageGo to next message
Michel Cadot
Messages: 64130
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Maybe your application should have to display the result?

Regards
Michel
Re: refcursor not displaying the output [message #252959 is a reply to message #252875] Sat, 21 July 2007 00:12 Go to previous messageGo to next message
ritikaindu
Messages: 30
Registered: March 2007
Location: asas
Member

but rest of the procedures are showing the output when used in same way.i jave not got the reason why it is happening.

Ritika
Re: refcursor not displaying the output [message #252960 is a reply to message #252841] Sat, 21 July 2007 00:19 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
You have said I have a problem.
I am not getting the results I expect.

You have provided NOTHING that would allow any reader to reproduce what you report to be seeing.
How/why do you expect any meaningful answer?

You're On Your Own (YOYO)!
Re: refcursor not displaying the output [message #252971 is a reply to message #252959] Sat, 21 July 2007 02:11 Go to previous message
Michel Cadot
Messages: 64130
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It is normal rest of your procedures displays the result, this one not.

Regards
Michel
Previous Topic: Reading records from a file
Next Topic: dynamic cursor
Goto Forum:
  


Current Time: Wed Dec 07 10:53:35 CST 2016

Total time taken to generate the page: 0.11767 seconds