Re: Problem with CREATE PACKAGE

From: Roger Bjaerevall <ebcrbj_at_ebcw150.ericsson.se>
Date: Tue, 2 Aug 1994 04:42:52 GMT
Message-ID: <1994Aug2.044252.8772_at_ericsson.se>

In article 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

Do you have the Procedural Option correctly installed?

Check by entering SQL*Plus. The initial output shall look like this:

.
.
.

ORACLE7 Server Release 7.0.16.4.0 - Production With the procedural option
PL/SQL Release 2.0.18.1.0 - Production

.
.
.

+------------------------------------------------------------------+
+       _/_/_/    _/_/_/   _/_/_/_/  Roger Bjärevall               +
+      _/    _/  _/    _/       _/   BO/EBC/FL/RGFC                +
+     _/    _/  _/    _/       _/    Ericsson Business Networks AB +
+    _/_/_/_/  _/_/_/_/       _/     135 83 Tyresö                 +
+   _/  _/    _/    _/  _/   _/      Sweden                        +
+  _/    _/  _/    _/  _/   _/       +46 8 6824851                 +
+ _/     _/ _/_/_/      _/_/         email: ebcrbj_at_ebc.ericsson.se +
+------------------------------------------------------------------+

Received on Tue Aug 02 1994 - 06:42:52 CEST