DBMS_PIPE:A Summary of Configurations

PS: Thanks to all those who replied...!  

1. DBMS_PIPE is NOW easy and fun to use, but beware of certain configuration steps.
2. For the developer's userid and the user's userid, remember to grant execute the procedure revelant procedures to them.
3. Once this ok, the stored procedures or functions you build can be compiled successfully.
4. The examples involving PL/SQL blocks in Pro*C cannot work immediately.

    You need to modify the proc.mk file. One way is as follows.  

    After the section  

    PROC=$(ORACLE_HOME)/bin/proc

    PROFOR=$(ORACLE_HOME)/bin/profor
    PROCOB=$(ORACLE_HOME)/bin/procob
    PROPAS=$(ORACLE_HOME)/bin/propas
    PROADA=$(ORACLE_HOME)/bin/proada
 

    and before the section  

    PROFLAGS=ireclen=132 oreclen=132 select_error=no $(SQLCHECK) $(PROUSER)  

    add  

    SQLCHECK=sqlcheck=semantics
    PROUSER=userid=userid/userpassword  

    where userid and userpassword are that of the developer. Oracle     checks to ensure that the objects which u specify exist in the     schema.  

5. With this in mind, compilation should be a breeze.    

Thanks again.     Received on Thu Nov 17 1994 - 01:13:18 CET