Message-ID: <39E2AD82.6F44C78F@sympatico.ca>
From: Greg Caulton <gcaulton@sympatico.ca>
X-Mailer: Mozilla 4.5 [en] (Win98; I)
X-Accept-Language: en,pdf
MIME-Version: 1.0
Newsgroups: comp.databases.oracle,comp.databases.oracle.misc,comp.databases.oracle.server
Subject: Re: Oracle Lite Replication Insert Errors
References: <39E26714.40787525@sympatico.ca> <=JviOXBt1vDi1x6ie81mdkMvGYiw@4ax.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 29
Date: Tue, 10 Oct 2000 05:47:54 GMT
NNTP-Posting-Host: 64.229.66.253
X-Trace: news20.bellglobal.com 971156874 64.229.66.253 (Tue, 10 Oct 2000 01:47:54 EDT)
NNTP-Posting-Date: Tue, 10 Oct 2000 01:47:54 EDT
Organization: Sympatico


ahhh cool... that fixed it, many thanks.

Serg Stone wrote:

> >However if I update locally, the refresh errors with:
> >REPAPI-26536: refresh was aborted...
> >REPAPI-26513: push error: master proc. PERSON$RP.rep_update() failed for
> >trans:54 seq:1
> >ORA-06550: line 1, column 7:
> >PLS-00201: identifier 'CAREGIVER.PERSON$RP' must be declared
> >ORA-06550: line 1, column 7:
> >PL/SQL: Statement ignored
> >
> >A similar error occurs if I insert locally.  I'm assuming I have some
> >scripts to perhaps run on the server - or maybe some additional setup of
> >my tables for replication so I'll dig around - but if anyone is familiar
> >with this stage I'd love to hear some ideas.
>
> You have to generate replication support on master site for your
> replication objects. It is made by running
> DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT
> for all of your objects that need it.
> This procedure creates packages with necessary functions to insert,
> delete or update data in your master table
> (PERSON$RP.rep_update(),PERSON$RP.rep_delete() and
> PERSON$RP.rep_insert()).
>
> Serg Kamnev aka Serg Stone              serg_stone@iname.com