Re: ORA-00942

From: Billy Verreynne <vslabs_at_onwe.co.za>
Date: 1998/03/16
Message-ID: <6el4fu$ikr$2@hermes.is.co.za>#1/1

Ikenna Aniagoh wrote in message <6ekn46$ao3_at_bgtnsc02.worldnet.att.net>...
>I am developing using Delphi 3 and Oracle 8 as the backend. When I run the
>program I get this error.
>
>"ORA-00942 table or view does not exist". Can someone please tell me what
to
>do.

Funny thing is that in Oracle the error message is usually right. So if Oracle says that it does not have the faintest idea about the table/view that you try to reference, you better believe it.

So, either create the table/view you're trying to use, or make sure you specify the table owner together with the tablename, e.g. doris.customers instead of just customers. Received on Mon Mar 16 1998 - 00:00:00 CST