0

I am passing a select query from java, it works for all table but one of the table gets an error "ora-00942 table or view does not exist". I checked grant and all, its same for all table. But for some reason it complains abtout this particular table. But if I run the same query in sql plus it works completely fine. Can someone tell me what may be the reason behind it. Thank you

Improve this question
2
  • 2
    Post the code. Is the schema correct? Are you using a synonym? Commented Oct 19, 2011 at 14:17
  • Login as the Java user (J2USER perhaps?) and run the same query. Commented Oct 19, 2011 at 14:34

1 Answer 1

Reset to default
5

I suspect you are using a different user from sqlplus than from your Java program, and then the error is caused by a missing synonym/schema name.

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.