I can not execute procedures from OAS servlets.

[Guest_imported]

I have servlets based application which logic is build on pl/sql procedures. All tables and procedures are instaled into one schema. I can use my java servlet application with owner of pl/sql procedures and tables. I created user with create session, create synonym and execute procedures privilages. After what I created synonyms on all procedures. After all I can not use my web application with this user. Servlet error occurs with message :table or view does not exist. That is very strange because from SQL Plus I can execute every procedure.

 

[carp]

I suspect that your applets are not connecting the way you think they are or you have private synonyms in the wrong schema..

A couple of things to try:

1. Watch v$sessions and then start up one of your applets. This should tell you who the applet is connecting as.

2. Make sure your synonyms are public synonyms.

3. If necessary (and permissable), grant execute on the procedure to public.