Re: DBMS_PIPE not working

Joseph Strano wrote:
>
> Dennis R. Otero wrote:
> >
> > Using forms 4.5.6.5.5 I am trying to use the DBMS_PIPE.PACK_MESSAGE but
> > I keep getting an error "qualified 'DBMS_PIPE' must be declared".
> > I can describe the command but can't use it, How do I declare it?
> >
> > Dennis R. Otero
> > United Space Alliance
> > Kennedy Space Center
>
> Ensure grants on the DBMS_PIPE package were granted. Unfortunately,
> they are not granted by default. Log in as SYS (not SYSTEM) and grant
> execute rights to the package to the user you want.
>
> Joe Strano
> Dulcian, Inc.

Also, you can not access DBMS_PIPE directly from Forms. The procedure calling DBMS_PIPE must reside at the database level. DBMS packages use PL/SQL version 2.

Joe Strano
Dulcian, Inc. Received on Mon Feb 17 1997 - 00:00:00 CET