Re: ORACLE dbms_pipe package error: request for help

>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

I've never seen the ICD error, but I suspect that your package didn't compile correctly when you created it on the server. Check ALL_ERRORS after you create the package to see if there were any problems. It looks as if it were at line 34.

                                                Dave Trahan
                                                BrainTree Technology, Inc
                                                p00775_at_psilink.com