how to debug package procedures without parameters
When trying to debug a package having some functions and procedures with and without Parameters, functions and procedures having Parameters are listed when trying to start the corresponding objects. Procedures without Parameters however are not displayed as package members. When adding a dummy Parameter to the parameterless procedures, they are displayed.
Is there a solution for this behavior?
Example:
Using the below code, SQLDeveloper only offers truncate_tables as candidate for Debugging. When using testproc(dummy number) both, the function and the procedure can be seen in the candidates list.
CREATE OR REPLACE PACKAGE "TEST" AS
FUNCTION truncate_tables RETURN NUMBER;