Re: Oracle Lite Replication Insert Errors

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_at_iname.com
Received on Tue Oct 10 2000 - 00:47:54 CDT