doubt about package in oracle SQL developer

1710228 Sep 10, 2018 12:36 PM

Hello,
I am using version 18.1.0.095 of Oracle sql developer, and I have a question, when creating a package I created the specification and the body.
I declare the procedure in the specification as well, but if I need to create a new procedure if I do not declare it in the specification when trying to perform a debug it does not offer the option to start the debug for it, I have already been able to do this in other tools my doubt is if this can be done by a configuration adjustment in sql developer or if this is impossible.

1. Re: doubt about package in oracle SQL developer

thatJeffSmith-Oracle Sep 10, 2018 4:08 PM (in response to 1710228)

we're looking in DBA_PROCEDURES, which doesn't appear to publish private procedures in a package - where it's in the body but not the spec.
1 person found this helpful
Like Show 1 Likes(1)

Actions
2. Re: doubt about package in oracle SQL developer

1710228 Sep 10, 2018 1:55 PM (in response to thatJeffSmith-Oracle)

thank you very much for the clarifications
Like Show 0 Likes(0)

Actions
3. Re: doubt about package in oracle SQL developer

rp0428 Sep 10, 2018 3:25 PM (in response to 1710228)

A private package function/procedure can ONLY be called from within the package.

So the first thing you need to do is create a package PUBLIC function/procedure that calls the private one.
Like Show 1 Likes(1)

Actions

Go to original post