Skupiny Google už nepodporují nová předplatná ani příspěvky Usenet. Historický obsah lze zobrazit stále.

Linux and Oracle for SCO-Unix

0 zobrazení
Přeskočit na první nepřečtenou zprávu

Juergen Kraus

nepřečteno,
3. 10. 1998 3:00:0003.10.98
komu:
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@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>
------------------------------------------------


Maya Katincic

nepřečteno,
3. 10. 1998 3:00:0003.10.98
komu: Juergen Kraus
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

Atif Ahmad Khan

nepřečteno,
3. 10. 1998 3:00:0003.10.98
komu:

You might also want to try Oracle for Linux and not Oracle
for SCO. See technet.oracle.com.


0 nových zpráv