1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Question about DBMS_REPCAT_INTERNAL_PACKAGE

Discussion in 'SQL PL/SQL' started by tripower, Aug 12, 2010.

  1. tripower

    tripower Active Member

    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    55
    I am a .NET programmer and I am new to the oracle REPLICATION world. I have come across the following replications packages/procedures:

    procedure rep_insert(
    parm1 IN VARCHAR2,
    parm2 IN VARCHAR2

    ) is
    begin
    DBMS_REPCAT_INTERNAL_PACKAGE.CALL();
    DBMS_REPCAT_INTERNAL_PACKAGE.VARCHAR2_ARG("parm1");
    DBMS_REPCAT_INTERNAL_PACKAGE.VARCHAR2_ARG("parm2");
    end rep_insert;

    What exactly is DBMS_REPCAT_INTERNAL_PACKAGE and how do I get to it to see what is going on here?
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,345
    Likes Received:
    347
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    As its name states it's an internal package that supplies functionality to the dbms_repcat procedures and functions and, as it's an internal package it's code is not visible to anyone outside of the Oracle developers who created it. You will find that the code has been 'wrapped', an Oracle-supplied utility to obfuscate source code. Oracle does NOT provide any utility to 'unwrap' such code.