Re: Problem with CREATE PACKAGE

From: Scott Urman <surman_at_wwsun10.us.oracle.com>
Date: 1 Aug 1994 17:48:13 GMT
Message-ID: <31jcgt$b1i_at_dcsun4.us.oracle.com>


In article <31j2ce$n9o_at_nameserver.lif.de>, barth_at_newsserver (Juergen Barth) writes:
|> Whenever I submit a
|> CREATE PACKAGE name AS ...
|> I get an errormessage
|>
|> CREATE PACKAGE emp_mgmt AS
|> *
|> ORA-00900: invalid SQL statement
|>
|> Even if I run dbmsstdx.sql as described in the SQL Language Reference Manual
|> page 4-164 I receive a similar errormsg. Does anybody know how to solve this
|> problem?
|>
|> We run Oracle 7.0.15.4 under SUN/OS 4.1.3
|>
|> Thanx Juergen
|> ---.

Try running catproc.sql as SYS. This will run all of the necessary scripts. Also make sure that you are using SQL*Plus 3.1, and not 3.0. Received on Mon Aug 01 1994 - 19:48:13 CEST

Original text of this message