Re: plsql error with ORACLE 7.1.6 to 7.3.3.6

From: R.Duke <*rduke_at_edcen.wrdsb.edu.on.ca>
Date: Thu, 06 Aug 1998 18:46:33 GMT
Message-ID: <35c9f90d.21702466_at_edcen>

On Thu, 06 Aug 1998 20:04:59 +0200, "Aurelio Martín" <aureliom_at_theglobe.com> wrote:

>You have to check if PL/SQL is linked with SQL*Plus in your Oracle installation.
>When you open a SQL*Plus session, the following messages must appear :
>
>SQL*Plus: Release 3...
>Copyright (c) Oracle Corporation ...
>
>Connected to:
>Oracle7 Server Release 7...
>...
>PL/SQL Release 2...
>
>SQL>
>
>If you don't see a line that begins with "PL/SQL..." then your SQL*Plus
>executable is not linked with PL/SQL and you cannot execute PL/SQL blocks.
>
>Hope that this works
>
Well sort of... I have posted below exactly what comes up on the banner when I start SQL*Plus

---

SQL*Plus: Release 3.3.3.0.0 - Production on Thu Aug 06 13:16:09 1998

Copyright (c) Oracle Corporation 1979, 1996. All rights reserved.

ERROR:
ORA-06501: PL/SQL: internal error , arguments: [], [], [], [], [], [], []
ORA-06553: PLS-906: Compilation is not possible

Error accessing package DBMS_APPLICATION_INFO You may need to install the Oracle Procedural option SET APPINFO requires Oracle Server Release 7.2 or later

Connected to:
Oracle7 Server Release 7.1.5.2.3 - Production Release PL/SQL Release 2.1.5.2.0 - Production

---

Now, I understand that SET APPINFO may be a feature slated for ORACLE Server 7.2 >, however, I do not beleive that it would interfere with my ability to execute procedures? Any further insight would be greatly appreciated as always. Recall, when I attempt to execute any PL/SQL code I get the ORA-06501 and ORA-06553 errors respectively.

Thanx in advance
Rob Received on Thu Aug 06 1998 - 20:46:33 CEST