Re: Pro*C Error

Make sure that the dbms_pipe has been installed on your database, and you have been granted execute permission on it. Try executing within sqlplus to see if it works there.

You might also need SQLCHECK=FULL and USERID=user/passwd options when running proc.

-Peter

Tom wrote:

> Hi:
>
> I am trying to process an Oracle Pro*C file which contains the following:
>
> 296 EXEC SQL EXECUTE
> 297 BEGIN
> 298 :v_Status := DBMS_PIPE.RECEIVE_MESSAGE('EXPORT_DRIVER');
> 299 END;
> 300 END-EXEC;
> 301 if (v_Status == 0) {
> 302 v_Code.len = 5;
> 303 EXEC SQL EXECUTE
> 304 BEGIN
> 305 DBMS_PIPE.UNPACK_MESSAGE(:v_Code);
> 306 END;
> 307 END-EXEC;
>
> PCC-S-0061: Error at line 298, column 31. PLS-201: identifier
> 'DBMS_PIPE.RECEIV
> E_MESSAGE' must be declared
> ....!
> PCC-S-0061: Error at line 298, column 9. PLS-0: Statement ignored
> ....!
>
> PCC-S-0061: Error at line 305, column 21. PLS-201: identifier
> 'DBMS_PIPE.UNPACK
> _MESSAGE' must be declared
> ......!
>
>
> Oracle generates the two above errors. How should I declare these
> functions? Is there initaializations code for the DBMS_PIPE package I'm
> missing?
>
> Please reply via e-mail -- and the newsgroup of course.
>
> Thanks,
Received on Mon Feb 16 1998 - 00:00:00 CST