?
Solved

DBMS_CDC_PUBLISH

Posted on 2007-03-28
1
Medium Priority
?
1,440 Views
Last Modified: 2013-12-19
begin
dbms_cdc_publish.alter_change_table (
   owner => 'P_RM',
   change_table_name => 'X_CITY',
   opertaion => 'ADD',
   column_list => ' TEST CHAR(1)',
   rs_id => 'N',
   row_id => 'N',
   user_id => 'N',
  timestamp => 'N',
  object_id => 'N',
  source_colmap => 'N',
  target_colmap => 'N');
end;
When i run above code then following error occurred
PLS-00306 ---Wrong Number or Types of Aurguemtns in call to Alter_change_table
it is confirmed  that schema 'P_RM' and table 'X_CITY' are exist.
0
Comment
Question by:Asif_Rafique
1 Comment
 
LVL 78

Accepted Solution

by:
slightwv (䄆 Netminder) earned 375 total points
ID: 18808694
Typo in operation:

 operation => 'ADD',
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to take different types of Oracle backups using RMAN.
Suggested Courses

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question