Re: Procedural Option, how to install it?

On Jan 25, 9:26 am, "Frank R." <tre..._at_gmail.com> wrote:
> 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. Can someone help me on this?
>
> Thanks in advance.

You didn't read the error message carefully enough. (BTW: I would stop using non-Oracle locations for the documentation. Oracle may update the documentation. Do you think a separate copy will get updated too?)
>From the same doc

Action: Correct the syntax or install the Procedural Option.

You didn't verify whether the syntax of the affected statement is correct, nor did you verify whether the Procedural Option is installed (Likely it is, or otherwise you can't do almost anything). And how to install the Procedural Option is described in the installation documentation.

-- 
Sybrand Bakker
Senior Oracle DBA