Re: Procedural Option in Oracle 7.3

Thanks,

             I'll give that a go. I had wondered about catproc as our software is supposed to run it whilst installing the database and always seemed to in the past.

Phil

David Ng wrote in message <7mvdtl$oc$1_at_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 - 21:24:05 CDT