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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Help: error message ORA-06554, why?

Re: Help: error message ORA-06554, why?

From: Campbell White <Preveal2_at_vni.net>
Date: 1997/02/03
Message-ID: <32F63112.194D@vni.net>#1/1

YNLONG wrote:
>
> I run a PL/SQL like below:
>
> Create Or Replace Function GetExamNo (pExam_date in date,pSick_cal......
> .................
>
> but SQL/PLUS return a error message like below:
>
> ORA-06554: package DBMS_STANDARD must be created
> before using PL/SQL.
>
> but I had been run the SQL script DBMSSTDX.SQL,
> Can anyone tell me why have the error message?
>
> Thank's!

From "Instant Messages" http://www.revealnet.com

   Oracle Product Document Library (C) Oracle Corporation   Manual: ORACLE 7.3 SERVER CODES Reference: A14538-16

 ORA-06554      package DBMS_STANDARD must be created before
          using PL/SQL

  Cause:  The data dictionary script required by PL/SQL has
          not yet been run.

  Action: See the Oracle7 Server Administrator's Guide and
          your Oracle7 operating system-specific
          documentation for more information.

Best wishes,

Cam White
RevealNet, Inc.
(202) 234-8557 Received on Mon Feb 03 1997 - 00:00:00 CST

Original text of this message

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