Re: DB 7.3 problems with tablenames

I doubt that the name is a problem. It is often the case that the previous line of code was improperly formated or formed. The compiler was confused and decided the table was incorrect.

Alternatively is the you need the schema for the table

    select * from user1.LOP where...

You should post the code for people to review.

Mike Krolewski

PCWS050 wrote:

> Problem:
> I' ve defined a table called "LOP" which i can access with SQL*Plus.
> When i use this table within a PL/SQL program i get compilation errors as
> follows:
>
> PLS-00356: 'LOP' must name a table to which the user has access
>
> i' ve then renamed the table to 'L_O_P' and ... it worked! But this can't
> be a solution.
>
> In the meantime, there's another such 'tablename' problem, so
>
> WHERE'S THE BUG? (naming conventions, reserved words, ...)
>
> Who can help?
>
> ThanX, Jürgen
Received on Fri May 01 1998 - 09:36:42 CEST