This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line!
See this thread for details.
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


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: 32481
    
214

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?


[OCA 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, 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: 32481
    
214

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.
 
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com
 
subject: oracle error
 
It's not a secret anymore!