Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Linux and Oracle for SCO-Unix
The error message you are getting means that you have not
installed the Procedural Option, required to run PL/SQL.
That is also obvious from your SQL*Plus connection. When
Procedural Option is installed, PL/SQL banner is displayed
when you start SQL*Plus.
To install Procedural Option you need to run catproc.sql
script located in $ORACLE_HOME/rdbms/admin directory,
connected as user SYS or INTERNAL.
Regards
Maya
Juergen Kraus wrote:
> We´ve installed Oracle 7.3.4.0.0 on a linux machine at work. All works
> fine, but only with normal SQL statements. But when we try to execute
> PL/SQL commands, the error ´ORA-00900: invalid SQL statement´
> occurs.
>
> Did anyone had the same experience with Oracle for SCO-Unix on Linux
> machines?
>
> For example, the following error messages occurs, when we start
> sqlplus...
> ------------------------------------------------
> oracle_at_linux2:/home/oracle/7.3.4.0.0/rdbms > sqlplus system/manager
>
> SQL*Plus: Release 3.3.4.0.0 - Production on Sat Oct 3 12:20:55 1998
>
> Copyright (c) Oracle Corporation 1979, 1996. All rights reserved.
>
> ERROR:
> ORA-00900: invalid SQL statement
>
> Error accessing package DBMS_APPLICATION_INFO
> ERROR:
> ORA-00900: invalid SQL statement
>
> Connected to:
> Oracle7 Server Release 7.3.4.0.0 - Production
>
> SQL>
> ------------------------------------------------
Received on Sat Oct 03 1998 - 08:39:18 CDT