Display results Stored procedure resturns SYS_REFCUR

Toad for Oracle
1

Hello everybody,

I'm using Toad 12.10 and Oracle 11 64 bits. I've a package of stored procedure and when I execute a procedure that returns a sys_refcursor nothing is displayed as shown below

toad_result.png
toad_result.png1332×465 30 KB

Note that I've shoosen to display results in a grid as indicated below

result_options.png
result_options.png884×645 26.9 KB

Can anyone tell me were I'm wrong and how to resolve this problem.

Regards.

2

Double click the cell that says (CURSOR) and you should see a popup grid that allows you to scroll through the results.

3

I work in Toad for more than 12 years, but cannot find your advice Michael.

Could you download pic, highlight your “cursor cell” and upload her back?

P.S.

If you thought “Cursor” label of group component, then i would prefere label than cell.Otherwise still do not get it where?

4

This is window is new in the last couple of releases.

cursor.jpeg
cursor.jpeg1332×465 166 KB

5

In the OP's first screenshot the main node for the cursor argument has a cell in the output column having text (CURSOR). Double click there. That could be visualized differently to be clearer.

On May 10, 2017, at 6:35 AM, Damir Vadas bounce-damirvadas_250@toadworld.com wrote:

RE: Display results Stored procedure resturns SYS_REFCUR

Reply by Damir Vadas
I work in TOad for more than 12 years, but cannot find your advice Michael.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle Forum notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

6

Thx Michael.