Re: Oracle Lite Replication Insert Errors

>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 Mon Oct 09 2000 - 23:37:01 CDT