DB 7.3 problems with tablenames
From: PCWS050 <juergen.weber_at_be.softlab.ch>
Date: 30 Apr 98 13:25:00 GMT
Message-ID: <01bd7444$242c19b0$bb384d8d_at_pcws050>
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:
Date: 30 Apr 98 13:25:00 GMT
Message-ID: <01bd7444$242c19b0$bb384d8d_at_pcws050>
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 Thu Apr 30 1998 - 15:25:00 CEST