Re: Advanced Replication of Procedures, Functions, and Packages

OK, so no errors anywhere, including the snapshot trace files? Then can you send us the steps you're going through? If you've got it all in a script, send that rather than describing it in words, because it's easier to see what's missing from a script.

Pete

"Chris R. Donnelly" wrote:

> It simply won't replicate the procedure on updates. There are no error
> messages from either Oracle Replication Manager or in the databases' dump
> directories (i.e., the database jobs are running successfully). The
> procedure is replicated only when it is first added to the master group and
> no other time (even if the procedure is later dropped on the non-masterdef
> server).
>
> // Chris
>
> Pete Sharman <psharman_at_us.oracle.com> wrote in message
> news:37D597B6.DB1B1496_at_us.oracle.com...
> > 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 Thu Sep 09 1999 - 10:43:10 CDT