Re: catproc.sql: problem with create or replace package statement

Jenny Barrett (jbarrett_at_s.psych.uiuc.edu) wrote:
: Has anyone had the problem when running catproc.sql from sqldba as SYS?
 

: I tried creating some procedures and triggers and got the message:
: ORA-00900: invalid SQL statement so I ran _at_catproc as SYS (with the database
: opened) and got the following messages:
 

: create or replace package body STANDARD is
: *
: ORA-00900: invalid SQL statement
: ORA-04043: object DBMS_STANDARD does not exist
: create package dbms_standard is
: *
: ORA-00900: invalid SQL statement
: create package body dbms_standard is
: *
: etc.
 

: The errors seem to start when catproc.sql executes standard.sql and the scripts
: following it. These are the scripts to set PL/SQL. Then I get a continuous
: stream of errors.
 

: Thanks very much,
: Jenny Barrett

  Make sure PL/SQL is installed in the oracle binary. You can check this by   connecting in SQLPlus... Look for some thing like :   Connected to:
  ORACLE7 Server Release 7.0.15.4.0 - Production   With the procedural and distributed options   PL/SQL Release 2.0.17.1.0 - Production

  The last line is the most important. (distributed option is, hmmm, optional)

--
 --------------------------------------------------------------
 Joe Ahmann                                      ahmann_at_fs.com
 Fourth Shift Corp.                              (612) 851-1427
 JIT Enterprise Systems