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

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

Post by Siqiao » Fri, 05 Jan 1996 04:00:00



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      _____            |                    | |                   |

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