Oracle SQL Developer - sort stored procedures in window

[dechrist]

When running a procedure from inside Oracle SQL Developer (by clicking the green play button), the Run PL/SQL window pops up with the list of stored procedures in the package. They are not sorted, which if you have a lot of procedures it can be a real pain to scroll through to find the one you're looking for to run a test.

Is it possible to sort the list of procedures in the Run PL/SQL window? If so, how?

 

[SantaMufasa]

dechrist,

Here is a routine that you can tailor to filter procedures for different users and to sort in any order you wish:

select owner, procedure_NAME FROM DBA_PROCEDURES
WHERE PROCEDURE_NAME IS NOT NULL
  AND OWNER NOT LIKE 'SYS%'
ORDER BY PROCEDURE_NAME,OWNER;

Mufasa
(aka Dave of Sandy, Utah, USA)
“People may forget what you say, but they will never forget how you made them feel.

 

[LKBrwnDBA]

If you created the package with the procedures/functions out of order, that's how you will get them.



----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb