views:

1824

answers:

2

If I have a function which returns a reference cursor for a query, how can I view the result set of this in SQL Developer? Toad has a special tab for viewing the results of a reference cursor, this is the functionality I would like to find.

+4  A: 

Double click the cursor fields in your result record. On the right side there is a "..." icon. Click this and you'll see the contents

Robert Merkwürdigeliebe
A: 

Can someone post some screen shots as I cannot find this in my version of SQL Developer (2.1).

Andy Harris
Please post such things as comments, not answers, or post a new question.
skaffman