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
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
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. Please, can someone help me on this?
Thanks in advance.