ora-00942 error

[mihke]

When executing a program unit located in a form 6i, I get this error.
The error occurs when opening a cursor from a table which is in another schema.
In the cursor declaration I used schema.table to select from.
In sql nav when I run the query for this table I'm able to retrieve data from it.
Can you tell me whats wrong and why do I still get that error when running the form.
Thanks in advance
Mihai

 

[lewisp]

Check my response in the Oracle release 8 and 8i forum