Re: Help with running CATPROC.SQL??

From: Steve Phelan <stevep_at_pmcgettigan.demon.co.uk>
Date: 1997/03/10
Message-ID: <332446DF.5A11@pmcgettigan.demon.co.uk>#1/1

greg teets wrote:
>
> The documentation for Personal Oracle7 says that I must submit
> CATPROC.SQL as SYS in order to use procedures and packages.
> When I do that, I get the following error:
>
> Bind variable "CATPROC" not declared
>
> Would someone please let me know how to fix this?
>
> Thanks,
> Greg

The documentation is asking you to run the catproc.sql script.

Basically, fire up sqlplus and login as the user SYS, then use '@catproc.sql' to run the script (don't forget to prefix the file name with the actual directory that the catproc.sql script resides in - i.e. '@c:\orawin\rdbms\catproc.sql', or wherever the file is on your system). Oh, and don't forget the '@' symbol at the beginning.

Steve Phelan. Received on Mon Mar 10 1997 - 00:00:00 CST