Re: DBMS_PIPE in Oracle 7.3

SUMITS wrote:
>
> Hi Keith,
> I'm having a similar problem as you described below.
> I get the exact same message on lines which have DBMS_PIPE
> in it. Oracle 7.3 is running on an NT machine. Could
> you share your solution/insight on this problem.
> Thanks,
> Sumit
>
>

Hello,

I had the same problem using the DBMS_PIPE package. The reason was the i had not the necessary privileges to executing this package. First you can check the data-dictionary view 'ALL_OBJECTS', if the DBMS_PIPE package is not included you haven't the privileges. The SYS user must grant you the privileges.
Or the DBMS_PIPE package is not installed. In any case look to the 'Server Application Developer's Guide' chapter 8. PL/SQL Input/Output: Creating the DBMS_PIPE Package.

-- 
 +-------V-------+ Axel Bandt * ACB/EO-10 Software Development
 | A L C A T E L | Mobile Communication Division TD Berlin
 +---------------+ Email: Axel.Bandt_at_bln.sel.alcatel.de
      TELECOM