Re: Help with running CATPROC.SQL??

From: oracle <oracle_at_nightmare.com>
Date: 1997/03/10
Message-ID: <3324B337.1370@nightmare.com>#1/1

------------6AD18C270975
Content-Transfer-Encoding: 7bit
Content-Type: text/plain; charset=us-ascii

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

Make sure you run it with either "@" or "start". That is:

SQLDBA> @catproc
or
SQLDBA> start catproc

This should work. I have never done it on a PC but it should be the same as any other OS.

------------6AD18C270975
Content-Transfer-Encoding: 7bit
Content-Type: text/html; charset=us-ascii

<HTML><BODY>

<DT>greg teets wrote:<BR>

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

<BR></DT>

<DT>Make sure you run it with either "@" or "start". 
That is:</DT>

<DT> </DT>

<DT>SQLDBA> @catproc</DT>

<DT>  or</DT>

<DT>SQLDBA> start catproc</DT>

<DT> </DT>

<DT>This should work.  I have never done it on a PC but it should
be the same as any other OS.</DT>

<DT> </DT>

</BODY>
</HTML>

------------6AD18C270975-- Received on Mon Mar 10 1997 - 00:00:00 CST