Procedures With Double Quotes Are Not Visible In 'Run PL/SQL' Dialog (Doc ID 2178758.1)

Last updated on SEPTEMBER 02, 2016

Applies to:

Oracle SQL Developer - Version 4.1 and later
Information in this document applies to any platform.
Fixed in 4.2 when it is released according to the bug update.

Symptoms

Environment
-------------------
SQL Developer 4.1.3.20
Windows 8 x-64bit

Problem
----------------

Double quoted procedures/functions are not seen in 'Run PL/SQL' dialog. E.g. "MyProcedure" is not seen, while myprocedure is.

Steps to Reproduce 

----------------------

1. Create Package Spec:

create or replace package package1 as
procedure myProc1 ;
procedure "myProc2" ;
end;

2. Create Package Body:

create or replace package body package1 as
procedure myProc1 is
begin
dbms_output.put_line('Hello World');
end;
procedure "myProc2" is
begin
dbms_output.put_line('Hello World');
end;
end;

3. Highlight Package, Right Click and Choose Run, Brings up Run PL/SQL and shows only the MYPROC the one created without the " " double quotes.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms