File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

ORA-00942 How to figure out privileges problem

 
D Rog
Ranch Hand
Posts: 472
Linux Objective C Ubuntu
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Purushoth Thambu
Ranch Hand
Posts: 425
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Shailesh Chandra
Ranch Hand
Posts: 1082
Java Oracle Spring
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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

    Shailesh
     
    I agree. Here's the link: http://aspose.com/file-tools
    • Post Reply
    • Bookmark Topic Watch Topic
    • New Topic