Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Strange error, help please

Strange error, help please

From: Andrej Gabara <anga0004_at_stud.uni-sb.de>
Date: 1997/11/17
Message-ID: <879778766.21170@dejanews.com>#1/1

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



....

LANGUAGE
....

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 Usenet
Received on Mon Nov 17 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US