Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> declare SYS.DBMS_PIPE???

declare SYS.DBMS_PIPE???

From: Greg G <ggershSNACK_at_CAKEctc.net>
Date: Thu, 06 Nov 2003 09:17:25 -0500
Message-ID: <fJudnYBjA5GOxTeiRVn-ug@ctc.net>

This is really strange. I coped some code from another user's area in my database, but when I go to compile it, I get this message:

Line # = 32 Column # = 5 Error Text = PLS-00201: identifier 'SYS.DBMS_PIPE' must be declared

The code is really simple stuff, along the lines of
...

     dbms_pipe.pack_message(v_pname);
...

I can't find anything that tells me how, when, where or why to declare this.

Any ideas?

-Greg G Received on Thu Nov 06 2003 - 08:17:25 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US