aspose file tools*
The moose likes Oracle/OAS and the fly likes oracle  error Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "oracle  error" Watch "oracle  error" New topic
Author

oracle error

michelle davis
Greenhorn

Joined: Oct 14, 2013
Posts: 2
from a sql query that i built, i am receiving the below error. can someone help troubleshoot?

Error at line 149
Jeanne Boyarsky
author & internet detective
Marshal

Joined: May 26, 2003
Posts: 30758
    
156

Welcome to CodeRanch!

There are a few things to check for an error like this:
1) Does that table/object/trigger/whatever it is actually exist?
2) Does the user querying the database have access to it?
3) If it is a stored procedure, does it need to be recompiled?


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
michelle davis
Greenhorn

Joined: Oct 14, 2013
Posts: 2
it is a stored procedure. can you direct me on how to recompile?
Jeanne Boyarsky
author & internet detective
Marshal

Joined: May 26, 2003
Posts: 30758
    
156

In SQL Plus, you drill down to it and right click.

Incidentally, this SQL will tell you if the problem is that it is invalid.
 
 
subject: oracle error