I have a stored procedure which's called fine from SQL+, however gives above exception if called from Java code. How to figure out security constrains defined for a stored procedure? It's Oracle + JDBC question. Oracle version is 9.
Since you are getting ORA exception we can't term this has JDBC issue. Are you using the same login info for both SQL* and JDBC? If so, it's kind of strange unless in SQL* you are wrapping the exceptions while calling stored procedure. There isn't much to tell but you have to take a look at the procedure and objects used and debug.
probably you should look for the details of error code, which you got from oracle
ORA-00942 table or view does not exist
(Oracle version: 9i )
Cause: The table or view entered does not exist, a synonym that is not allowed here was used, or a view was referenced where a table is required. Existing user tables and views can be listed by querying the data dictionary. Certain privileges may be required to access the table. If an application returned this message, the table the application tried to access does not exist in the database, or the application does not have access to it.
Action: Check each of the following:
The spelling of the table or view name.
That a view is not specified where a table is required.
That an existing table or view name exists.
Also, if attempting to access a table or view in another schema, make certain the correct schema is referenced and that access to the object is granted
Gravitation cannot be held responsible for people falling in love ~ Albert Einstein