Re: Help: PL/SQL Compile ERROR

From: Henry Yick <92908250_at_cpccux1>
Date: Tue, 7 Feb 1995 23:23:06 +0800
Message-ID: <Pine.SOL.3.91.950207231803.11680C-100000-100000-100000-100000_at_cpccux1>

On Sun, 5 Feb 1995, Tim Smith wrote:

> Hello all,
>
> I'm having a problem compiling a PL/SQL package. I have supplied the code and
> error results below. I would appreciate it if some kind sole would help save
> my sanity and shed some light to what might be going here.
>
> I have defined the following package ...

.
.
.

> LINE/COL ERROR
> -------- -----------------------------------------------------
> 8/7 PL/SQL: Statement ignored

.
.
> 8/20 PLS-00201: identifier 'DBMS_PIPE' must be declared
> 11/7 PL/SQL: Statement ignored
>
> .... etc......
> Can anyone shed some light on this for me??????

You have to run the script $ORACLE_HOME/rdbms/admin/dbmspipe.sql (or something like that) using sys login before you compile your package.

---

      __       _        | Yick Ka Yuen, Henry | City Univserity of Hong Kong
 |_| |_  |\ | |_| \ /   | Email : 92908250_at_cpccux1.cityu.edu.hk
 | | |__ | \| | \  | .  | Computer Studies, Year 3/4 
-------------------------------------------------------------------------------

- Learn from yesterday, live for tomorrow. Received on Tue Feb 07 1995 - 16:23:06 CET