Re: Procedural Option in Oracle 7.3

From: David Ng <david_ng_at_attmysite.com>
Date: Mon, 19 Jul 1999 22:42:04 +0800
Message-ID: <7mvdtl$oc$1@m5.att.net.hk>

Phil,

Have you run catproc.sql when you create your database ? If not, run it. The
script locates in ?/rdbms/admin directory.

You can check if your database got this option when you start your sqlplus, it should state
if you have PL/SQL procedural option.

If you are not sure, ask your DBA.

David

Phil Chapman <pchapman_at_bellsouth.net> wrote in message news:T2Fk3.231$lg2.392_at_news1.mco...
> I have recently installed a new RS/6000 machine with AIX4.3 and them
Oracle
> 7.3.2. I have problems creating procedures/packages etc as get errors
> saying the procedural option must be on.
>
> I have tried reinstalling but do not see the option.
>
> Can anyone tell me where I am going wrong? Is it possible to switch this
on
> afterwards?
>
> Any information would be greatly appreciated.
>
> Thanks
>
> Phil
>
>
Received on Mon Jul 19 1999 - 09:42:04 CDT