Re: Strange error, help please

Andrej Gabara wrote:
>
> 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

Hi Andrej,

users using stored procedures must have granted rights for the underlying tables.

-- 
Regards

Matthias Gresz    :-)