Re: dbms_pipe & dbms_alert unavailable in my system?
From: Maarten Scharroo <m.scharroo_at_elsevier.nl>
Date: 9 Mar 1999 08:46:00 GMT
Message-ID: <01be6a09$43bf1a00$7d0c2491_at_C30487.elsevier.nl>
Date: 9 Mar 1999 08:46:00 GMT
Message-ID: <01be6a09$43bf1a00$7d0c2491_at_C30487.elsevier.nl>
Hi Brandon,
Try grant execute on sys packages to public. I think you'll need it.
Maarten
Brandon Lee <brand_at_tm.net.my> wrote in article
<36e4d718.0_at_news.tm.net.my>...
> hi anyone,
> how come i could not find the dbms_pipe and dbms_alert under my
'database
> objects.sys.stored program units' tree in my forms object navigator? I
> thought these should have been there when the database is installed.
When i
> try to compile a function which call dbms_pipe.receive_message, i get the
> following error message:
> PLS-00201: identifier 'SYS.DBMS_PIPE' must be declared
> how do i reinstall this packages to working order?
>
>
>
Received on Tue Mar 09 1999 - 09:46:00 CET