SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Viewing the ref cursor output in debug mode in sql developer

user8936847Sep 5 2012 — edited Nov 5 2012

Hi,
I am using SQL developer version 3.2 and trying to debug a procedure in it. The proc returns a ref cursor on its completion.

When I debug the proc, then I am not able to view the output of the ref cursor in the output window. However when I directly execute the proc(without debugging) then I can see the output of the ref cursor in the output tab.

Can anyone explain the reason for this strange behaviour. Below are the details of the versions I'm using

•Version of SQL Developer: 3.2.09
•Version of the JDK : JDK 1.6.0_11
•The OS : Windows 7
•The version of Oracle : Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bi
PL/SQL Release 10.2.0.3.0 - Production
CORE 10.2.0.3.0 Production
TNS for Linux: Version 10.2.0.3.0 - Production
NLSRTL Version 10.2.0.3.0 - Production

Regards
Deepak Aggarwal

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 3 2012

Added on Sep 5 2012

#sql-developer

7 comments

4,936 views