DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Replication-unique conflict

  1. #1
    Join Date
    May 2001
    Posts
    736
    Dear friends

    When Iam resolving a Unique conflict by executing the following procedure i got the following error .Can any one help me out with this error

    SQL> BEGIN
    2 DBMS_REPCAT.ADD_UNIQUE_RESOLUTIION(
    3 SNAME => 'CIDOW01',
    4 ONAME => 'GA_LISTDATA',
    5 CONSTRAINT_NAME => 'CPK_LISTDATA',
    6 SEQUENCE_NO => 1,
    7 METHOD => 'APPEND SEQUENCE',
    8 COMMENT => 'RESOLVE CONFLICT',
    9 PARAMETER_COLUMN_NAME => 'LIST_ID');
    10 END;
    11 /
    DBMS_REPCAT.ADD_UNIQUE_RESOLUTIION(
    *
    ERROR at line 2:
    ORA-06550: line 2, column 15:
    PLS-00302: component 'ADD_UNIQUE_RESOLUTIION' must be declared
    ORA-06550: line 2, column 3:
    PL/SQL: Statement

    regards
    akhadar

  2. #2
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    Hi,

    Are you executing this with the Replication Administrator user? Wich privilegies has it?

    Regards

    Angel

  3. #3
    Join Date
    May 2001
    Posts
    736
    Hello angel

    I tried to execute this procedure with system and Repadmin on both of these users iam getting the same error.Repadmin is having all the privileges on the procedure(alter,select,drop,execute)
    regards
    akhadar

    [Edited by akhadar on 02-11-2002 at 05:12 AM]

  4. #4
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    Originally posted by akhadar

    DBMS_REPCAT.ADD_UNIQUE_RESOLUTIION(

    [/B]
    Try with DBMS_REPCAT.ADD_UNIQUE_RESOLUTION



    Care with sintax

    Regards

    Angel

  5. #5
    Join Date
    May 2001
    Posts
    736
    Really it is foolish for not observing the syntax.
    Any how thank u the procedure is successfully executed.
    regards
    akhadar

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width