Re: HELP: dbms

From: Frank Hubeny <fhubeny_at_ntsource.com>
Date: 1997/11/28
Message-ID: <347F3EEE.680EEA2E@ntsource.com>#1/1

This is a multi-part message in MIME format. --------------54F28A6F425C771EBE8283E3
Content-Type: multipart/alternative; boundary="------------490A5594C4E6E51C3E0441B5"

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

I was able to get this to compile after logging in as sys and explicitly granting execute on the dbms_pipe package to the user who was attempting to compile the package.

The steps:

connect sys/password
grant execute on dbms_pipe to username;
connect username/userpassword
Then attempt to compile the package.

Leonid Lamburt wrote:

> I am trying to write a package that uses DBMS_PIPE Package:
> .......
> ......
> CREATE OR REPLACE PACKAGE BODY my_package AS
> PROCEDURE use_pipes IS
> i INTEGER;
> BEGIN
> i := dbms_pipe.create_pipe('tst_pipe');
> END use_pipes;
> END my_package;
> /

> It fails to compile with PLS-00201: identifier 'SYS.DBMS_PIPE' must be
> declared
> error.

> I have no trouble using DBMS_OUTPUT Package
> Also
> declare
> i integer;
> begin
> i := dbms_pipe.create_pipe('tst_pipe');
> end;

> executes fine

>
> What can be wrong? Any help will be appreciated...

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

<HTML>
I was able to get this to compile after logging in as sys and explicitly granting execute on the dbms_pipe package to the user who was attempting to compile the package.

<P>The steps:
<OL>
<LI>
<TT>connect sys/password</TT></LI>

<LI>
<TT>grant execute on dbms_pipe to username;</TT></LI>

<LI>
<TT>connect username/userpassword</TT></LI>

<LI>
Then attempt to compile the package.</LI> </OL>

Leonid Lamburt wrote:
<BLOCKQUOTE TYPE=CITE>I am trying to write a package that uses DBMS_PIPE Package:

<BR>.......
<BR>......
<BR>CREATE OR REPLACE PACKAGE BODY my_package AS
<BR>&nbsp; PROCEDURE use_pipes IS
<BR>&nbsp;&nbsp; i INTEGER;
<BR>&nbsp; BEGIN
<BR>&nbsp;&nbsp;&nbsp; i := dbms_pipe.create_pipe('tst_pipe');
<BR>&nbsp; END use_pipes;
<BR>&nbsp;END my_package;
<BR>/

It fails to compile with PLS-00201: identifier 'SYS.DBMS_PIPE' must be
 declared
 error.

<P>I have no trouble using DBMS_OUTPUT Package
<BR>Also
<BR>&nbsp;declare
<BR>&nbsp;&nbsp; i integer;
<BR>&nbsp;begin
<BR>&nbsp; i := dbms_pipe.create_pipe('tst_pipe');
<BR>&nbsp;end;

executes fine

What can be wrong? Any help will be appreciated...</BLOCKQUOTE>  </HTML>

--------------490A5594C4E6E51C3E0441B5--

--------------54F28A6F425C771EBE8283E3
Content-Type: text/x-vcard; charset=us-ascii; name="vcard.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for Frank Hubeny
Content-Disposition: attachment; filename="vcard.vcf"

begin:          vcard
fn:             Frank Hubeny
n:              Hubeny;Frank
adr:            427 East Liberty Drive;;;Wheaton;IL;60187-5510;USA

email;internet: fhubeny_at_ntsource.com
x-mozilla-cpt: ;0
x-mozilla-html: TRUE

version:        2.1
end:            vcard

--------------54F28A6F425C771EBE8283E3-- Received on Fri Nov 28 1997 - 00:00:00 CST

Re: HELP: dbms_pipe