Skip to Main Content

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!

Run PL/SQL Block to test or debug, no generated PL/SQL Block, dialogue box is empty

user10762200Oct 17 2017 — edited Oct 17 2017

I'm using SQL developer V 17.2.0.188 - 188.1159

When I right click on a PL/SQL Package and select the run option, it comes up with the "Run PL/SQL" dialogue box but in many cases the actual PL/SQL block is empty... however, not in all cases.  There doesn't seem to be a rhyme or reason for which procedures or functions generate the anonymous block.  If I attempt to run anyway I get PL/SQL errors (ORA-00900 and ORA-06512) with a mysterious line number 58 (Vendor Code 900) even though there is no generated code.  Same effect for Debug.

Anyone familiar with this issue?

Thanks,

Dave

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 14 2017
Added on Oct 17 2017
4 comments
604 views