Re: ORACLE dbms_pipe package error: request for help

In article <35557b$54_at_cherokee.advtech.uswest.com>, kirani_at_advtech.uswest.com (Shekhar Kirani) writes:
|> Hi:
|>
|> I am trying to use dbms_pipe package provided by ORACLE. When I invoke
|> a stored procedure that sends out data into a pipe, I am getting the
|> following error.
|>
|> ERROR at line 1:
|> ORA-06509: PL/SQL: ICD vector missing for this package
|> ORA-06512: at "KIRANI.DBMS_PIPE", line 34
|> ORA-06512: at line 1
|>
|> The error number -06509 is not listed in the developer's release manual
|> that I have access to. I would greatly appreciate if some one can
|> figure out what does ICD vector mean and what i need to do to get rid
|> of this error message.
|>
|> Thanks a lot,
|> shekhar kirani
|> --
|> ----------------------------------
|> 4001, Discovery Drive, Suite 270
|> Boulder CO-80303. (303)-541-6420.
|> ----------------------------------

The only thing that comes to mind here is the "KIRANI.DBMS_PIPE" part of your error message. The DBMS_PIPE package should be owned by SYS, and not by any other user. The script catproc.sql, found in $ORACLE_HOME/rdbms/admin, creates the dbms_pipe package and the other supplied packages. It should be run as SYS. Received on Wed Sep 14 1994 - 01:34:14 CEST