Sign Up to our social questions and Answers to ask questions, answer people’s questions, and connect with other people.
Login to our social questions & Answers to ask questions, answer people’s questions & connect with other people.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Please briefly explain why you feel this question should be reported.
Please briefly explain why you feel this answer should be reported.
Please briefly explain why you feel this user should be reported.
Hello
I have a procedure in custom schema which call Standard Oracle API to create Inventory Item but when i’m trying to run my code i’m getting this error
ORA-00942: table or view does not exist occurred
Is it possible to call an Oracle API from a custom schema?
it’s better and recommended from oracle to create your procedure on apps schema not on your custom schema.
regards.
Is it note better to have all custom objects on a custom schema and just assign necessary grants between objects ?
Or only for API’s is recommended to have them on the same schema ?
Is thre Oracle recommendations about this schemas?
Regards
All custom objects should resides on the custom schema like tables, sequences. when it comes to procedures and functions if they will read from the custom objects we have to create it on the custom schema. but if you have a procedure that calls standard API this procedure should be created on APPS schema.
You would have to grant the appropriate permissions to your custom schema.