Re: Advanced Replication of Procedures, Functions, and Packages

Chris

Bit difficult to tell what's going wrong from what you've described. Is there an error message you're getting, or is it just not replicating the procedure?

Pete

"Chris R. Donnelly" wrote:

> Hi everyone,
>
> I have set up multimaster replication between two Oracle 8i databases. The
> objects I am replicating between the two masters are a table and a stored
> procedure. The table data is replicating normally (i.e., a change on one
> database propagates to the other as expected). However, when I make a
> change to the stored procedure on the masterdef database, it does not
> replicate the changes in the procedure to the other database, either
> automatically or by manual execution. I have tried using both Replication
> Manager as well as directly executing the procedures in the DBMS_REPCAT
> package to no avail, as well as both synchronous and asynchronous
> replication (preferably using asynchronous). What do I need to do to
> replicate the stored procedure's DDL?
>
> // Chris

Received on Tue Sep 07 1999 - 17:54:46 CDT