R: Error in creating procedure

From: Riccardo Ferrari <riccardo.ferrari_at_informatica2.it>
Date: Tue, 9 Nov 1999 13:59:26 +0100
Message-ID: <8095vm$hqg$1@nslave2.tin.it>

I enclose documentation about this error:

PLS-00213: package STANDARD not accessible

Cause: The PL/SQL compiler could not find package STANDARD in the current Oracle database. To compile a program, PL/SQL needs package STANDARD.

Action: Make sure that package STANDARD is available in the current Oracle database, then retry the operation.

The problem is clear, the causes can be different. The simpler is bad installation (the package is really non installed). You should see the package in the Data Dictionary. Try the query:

select object_name from all_objects where object_type = 'PACKAGE' and object_name = 'STANDARD' and see if the package is selected. Probably it isn't and you have to ask for it being installed.

Riccardo

<klone5399_at_my-deja.com> wrote in message 8079aq$fbt$1_at_nnrp1.deja.com...
> I am trying to create a simple procedure in Oracle. I get the following
> error.
> ORA-06553: PLS-213: package STANDARD not accessible
>
> I could not find this error in Oracle documentation.
> I have given DBA rights to the user so it should not be an authorization
> issue. Any help would be appreciated
>
> Khurram
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Nov 09 1999 - 06:59:26 CST