Pro*C & PL/SQL block(dbms_pipe package), how to compile Pro*C programs with PL/SQL block and database packages in them?

From: Siqiao Li <br172_at_cleveland.Freenet.Edu>
Date: 1996/01/04
Message-ID: <4che0m$cpf_at_madeline.INS.CWRU.Edu>#1/1

Hi there,           

I was trying to compile the daemon.pc that Oracle sent me for implementing the 'system' or 'host' command from PL/SQL blocks using the DBMS_PIPE package.           

I got the following errors on my VAX/VMS system. Any ideas? I called Oracle and they have no idea to. They asked me to 'grant execute' for the dbms_pipe synonym and package to public and it still doesn't help.

---

Pro*C: Release 2.0.3.2.0 - Production on Thu Jan 4 14:05:48 1996      

Copyright (c) Oracle Corporation 1979, 1994. All rights reserved.   

System default option values taken from: ora_proc20:pmscfg.cfg  

        :status := dbms_pipe.receive_message('daemon');

.............................1

(1) PCC-S-02201, identifier 'DBMS_PIPE.RECEIVE_MESSAGE' must be declared

        :status := dbms_pipe.receive_message('daemon'); .........1
(1) PCC-S-02000, Statement ignored

          dbms_pipe.unpack_message(:command);

....................1

(1) PCC-S-02201, identifier 'DBMS_PIPE.UNPACK_MESSAGE' must be declared

          dbms_pipe.unpack_message(:command); ..........1
(1) PCC-S-02000, Statement ignored

---

Please send me email if you know the answers 'cuz I didn't read the group often.

thanx

--SQL

     o o o o o o o .  . .   ______________________ _____=======________
    o      _____            |                    | |                   |

  .][__n_n_|DD[ ====_____ |sli_at_biost.mskcc.org | |(212)-639-4445 (O) |

 >(________|__|_[_________]_|____________________|_|___________________|_
 _/oo OOOOO oo`  ooo   ooo  'o^o^o          o^o^o` 'o^o             o^o`

-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+ Received on Thu Jan 04 1996 - 00:00:00 CET