-
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
-
Hi,
Are you executing this with the Replication Administrator user? Wich privilegies has it?
Regards
Angel
-
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]
-
Originally posted by akhadar
DBMS_REPCAT.ADD_UNIQUE_RESOLUTIION(
[/B]
Try with DBMS_REPCAT.ADD_UNIQUE_RESOLUTION
Care with sintax
Regards
Angel
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|