Calling Oracle package owned by another user
58758Apr 2 2008 — edited Apr 8 2008Hi,
I was given access to a package owned by another user. If I use sqldeveloper/JDeveloper, I cannot see the objects, hence I cannot call the procedure within the package through Oracle DB adapter.
I know that the package exist. If I use SqlPlus, I can describe the package which mean I have execute privilege.
Within the database, I can create a synonym for package but cannot still reference the package and procedure within BPEL or ESB. Any thoughts?
Thanks.