Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Strange error, help please
Here's the deal (Oracle Server 7.3 on Windows NT):
I created a table called 'LANGUAGE' like this:
CREATE TABLE Language (
LangId NUMBER NOT NULL,
LangName VARCHAR2(60) NOT NULL UNIQUE,
PRIMARY KEY (LangId)
);
Then I inserted a row like this (SQL Worksheet) INSERT INTO Language VALUES (1, 'Fooish');
Worked fine. However, the following raises an error:
BEGIN
INSERT INTO Language VALUES (1, 'Fooish');
END;
I get the following error (in german):
ORA-06550: Zeile 2, Spalte 15:
PLS-00356: 'LANGUAGE' muß der Name einer Tabelle sein, auf die
der Benutzer Zugriff hat
ORA-06550: Zeile 2, Spalte 3:
PL/SQL: SQL Statement ignored
In english (my translation):
ORA-06550: Row 2, Column 15:
PLS-00356: 'LANGUAGE' must be the name of a table that the user
has access (rights) to.
I can run a select, update, delete, and insert just fine, as long as I don't put it in a block (begin ... end).
I checked for an object in 'ALL_OBJECTS' but no object with the name 'LANGUAGE' exists in any of the other schemas. I did create the table in my schema, and it also shows:
SQLWKS> SELECT object_name FROM user_objects WHERE object_type = 'TABLE'; OBJECT_NAME
If I change the table name to LANGUAGES, everything works fine. So what's the deal here with naming a table 'LANGUAGE'?
I appreciate any replies and thank's in advance, Andrej
-------------------==== Posted via Deja News ====----------------------- http://www.dejanews.com/ Search, Read, Post to UsenetReceived on Mon Nov 17 1997 - 00:00:00 CST