Home » SQL & PL/SQL » SQL & PL/SQL » Replicating Packages across instances (Oracle
Replicating Packages across instances [message #381109] Thu, 15 January 2009 05:21
Messages: 1
Registered: January 2009
Location: India
Junior Member
Hi guys,

Need a small help. Following is the requirement:-

I have 2 instances say ORCL1 & ORCL2. I want to replicate the change in a package/stored procedure in ORCL1 to ORCL2. That is if i make a small change in my package/proc and compile in ORCL1, then same change should be applied & compiled in ORCL2.

Is this possible?

I checked the Advanced Replication feature provided by Oracle(procedural replication). But all that it does is replicate the call to a stored proc/package instead of editing it and compiling it.

Please suggest.

Thanks & Regards,

[Updated on: Thu, 15 January 2009 05:24]

Report message to a moderator

Previous Topic: Select last record in a group depending on a condition
Next Topic: How to send email from PL/SQL
Goto Forum:

Current Time: Thu Aug 17 16:38:34 CDT 2017

Total time taken to generate the page: 0.13956 seconds