Procedural Option, how to install it?

From: Frank R. <trek1s_at_gmail.com>
Date: 25 Jan 2007 00:26:40 -0800
Message-ID: <1169713600.101203.226450@l53g2000cwa.googlegroups.com>

Hello,

Some of my fellow developers is getting an ORA-900 error when trying to issue an "exec <PROCEDURE>...." from toad and other external server apps.

Regarding the explanation of the error in oracle documentation (http://www.lc.leidenuniv.nl/awcourse/oracle/server.920/a96525/e900.htm) it seems that if the PL/SQL info does not appear in the SQL*Plus banner the component is not installed.

I tried as suggested:

$ sqlplus "/as sysdba"

SQL*Plus: Release 9.2.0.7.0 - Production on Thu Jan 25 09:00:32 2007

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.7.0 - 64bit Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.7.0 - Production

SQL> select * from v$version;

BANNER

Oracle9i Enterprise Edition Release 9.2.0.7.0 - 64bit Production PL/SQL Release 9.2.0.7.0 - Production
CORE 9.2.0.7.0 Production
TNS for IBM/AIX RISC System/6000: Version 9.2.0.7.0 - Production NLSRTL Version 9.2.0.7.0 - Production

SQL> select comp_name, version, status from dba_registry

COMP_NAME                                          VERSION
          STATUS
--------------------------------------------------
------------------------------ ------------------------------
Oracle9i Packages and Types                        9.2.0.7.0
          VALID
Oracle9i Catalog Views                             9.2.0.7.0
          VALID
Oracle Workspace Manager                           9.2.0.1.0
          VALID

I am a bit puzzled since SQL*Plus banner does not show PL/SQL info but v$version does. Anyway, I still haven't found in the web/metalink a way to reinstall Procedural Option. Can someone help me on this?

Thanks in advance. Received on Thu Jan 25 2007 - 02:26:40 CST