SQL*Plus (MOSC)

MOSC Banner

how to debug package procedures without parameters

edited Apr 23, 2015 5:10PM in SQL*Plus (MOSC) 6 commentsAnswered ✓

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;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center