• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

oracle error

 
michelle davis
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 34669
366
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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?
 
michelle davis
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
it is a stored procedure. can you direct me on how to recompile?
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34669
366
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Consider Paul's rocket mass heater.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic