While working with oracle packages, we do develop package and test it on backend. it works fine.
but when we make a call to package from front end i.e. using code, it throws an error saying 'Object does not exits'.

Solution: It is because whenever we create any object in oracle and wish to access from outside backend, we always take of two things:

- Create synonyms for each object you wish to access
- assign privileges i.e. rights GRANTs to the users who can access this object

it will sort out problem.


No responses found. Be the first to comment...

  • Do not include your name, "with regards" etc in the comment. Write detailed comment, relevant to the topic.
  • No HTML formatting and links to other web sites are allowed.
  • This is a strictly moderated site. Absolutely no spam allowed.
  • Name: