Calling private function present in a package
927509Jan 18 2013 — edited Jan 18 2013HI.
I am using SQL developer 1.5.5,
I need to call a function which is inside a package body, but this function is not present in the package specification.
This can be accessed by other procedures in the same package.
I need to just call this function in this package in the SQL developer,
I tried,
- package_name.function_name(:par1,:par2)
- exec package_name.function_name(:par1,:par2)
- call package_name.function_name(:par1,:par2)
- select package_name.function_name(:par1,:par2) from dual;
none of these seems to work.
Any idea how do I call a this function, which is not part of package specification.
If this question doesn't fit in this forum,
apologies.. and kindly point where this question belongs.
Thank you.