Re: ORA-00942

From: Alan MCCulloch <amccullo_at_ccu1.auckland.ac.nz>
Date: 1998/03/23
Message-ID: <6f4k0k$nn8$1@scream.auckland.ac.nz>#1/1

"Billy Verreynne" <vslabs_at_onwe.co.za> writes:
>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.

This might not be relevant, but in Delphi 2 <-> Oracle 7, you have to have Oracle table/view names in upper case, if you are doing live TQueries, i.e. where you can update, else you get messages like that

AMcC Received on Mon Mar 23 1998 - 00:00:00 CST