Not able to see Procedure/Function body in Oracle SQL developer

Question

I am not able to see Procedure/Function body in package view Oracle SQL Developer connected to Oracle 11g.. Any idea how can I see that

Answer 1

You should be able to see the pacakge body if you press the plus (+) button you had right at the name of your pacakge.

If you don’t see it, two things may be happening, you don’t have the permissions (grants) on the user with which you are connected to the database session or the package body doesn’t exist.

To check if the package body exist you could export the definition,

You should also check if you are connected to the right environment