Home » SQL & PL/SQL » SQL & PL/SQL » PLS-00306: wrong number or types of arguments in call to 'CREATE_CHANGE_SET'
PLS-00306: wrong number or types of arguments in call to 'CREATE_CHANGE_SET' [message #259982] Fri, 17 August 2007 01:34 Go to next message
nagaa
Messages: 33
Registered: August 2007
Location: chennai
Member
Hi,

In CDC, while i'm creating the change set table i received an above error.
Following is the code for the creationj of change set table

begin
DBMS_CDC_PUBLISH.CREATE_CHANGE_SET(
change_set_name => 'SYNC_SET',
description => 'Change set name for emp',
change_source_name => 'SYNC_SOURCE');
end;
/

Error is

ERROR at line 2:
ORA-06550: line 2, column 1:
PLS-00306: wrong number or types of arguments in call to 'CREATE_CHANGE_SET'
ORA-06550: line 2, column 1:
PL/SQL: Statement ignored

Thanks,
Nagaa


Re: PLS-00306: wrong number or types of arguments in call to 'CREATE_CHANGE_SET' [message #259984 is a reply to message #259982] Fri, 17 August 2007 01:41 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Try to DESCRIBE and cross check.

By
Vamsi
Re: PLS-00306: wrong number or types of arguments in call to 'CREATE_CHANGE_SET' [message #260003 is a reply to message #259984] Fri, 17 August 2007 02:28 Go to previous messageGo to next message
nagaa
Messages: 33
Registered: August 2007
Location: chennai
Member
vamsi,

Now i received an error

Component "CREATE_CHANGE_SETS()" must be declared..


Thanks,
Nagaa
Re: PLS-00306: wrong number or types of arguments in call to 'CREATE_CHANGE_SET' [message #260006 is a reply to message #260003] Fri, 17 August 2007 02:30 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
You have an extra trailing S
Re: PLS-00306: wrong number or types of arguments in call to 'CREATE_CHANGE_SET' [message #260022 is a reply to message #260006] Fri, 17 August 2007 02:59 Go to previous messageGo to next message
nagaa
Messages: 33
Registered: August 2007
Location: chennai
Member
Hi,
when i describe the table

SQL> desc change_sets
Name Null? Type
----------------------------------------- -------- ----------------------------
SET_NAME NOT NULL VARCHAR2(30)
CHANGE_SOURCE_NAME NOT NULL VARCHAR2(30)
BEGIN_DATE DATE
END_DATE DATE
BEGIN_SCN NUMBER
END_SCN NUMBER
FRESHNESS_DATE DATE
FRESHNESS_SCN NUMBER
ADVANCE_ENABLED NOT NULL VARCHAR2(1)
IGNORE_DDL NOT NULL VARCHAR2(1)
CREATED NOT NULL DATE
ROLLBACK_SEGMENT_NAME VARCHAR2(30)
ADVANCING NOT NULL VARCHAR2(1)
PURGING NOT NULL VARCHAR2(1)
LOWEST_SCN NOT NULL NUMBER
TABLESPACE NOT NULL VARCHAR2(30)

Thats y i have used

SQL> ed
Wrote file afiedt.buf

1 begin
2 DBMS_CDC_PUBLISH.CREATE_CHANGE_SETS(
3 set_name => 'SYNC_SET',
4 change_source_name => 'SYNC_SOURCE');
5* end;
SQL> /
DBMS_CDC_PUBLISH.CREATE_CHANGE_SETS(
*
ERROR at line 2:
ORA-06550: line 2, column 18:
PLS-00302: component 'CREATE_CHANGE_SETS' must be declared
ORA-06550: line 2, column 1:
PL/SQL: Statement ignored


But still i received error....

if i change the code as
SQL> ed
Wrote file afiedt.buf

1 begin
2 DBMS_CDC_PUBLISH.CREATE_CHANGE_SET(
3 set_name => 'SYNC_SET',
4 change_source_name => 'SYNC_SOURCE');
5* end;
SQL> /
DBMS_CDC_PUBLISH.CREATE_CHANGE_SET(
*
ERROR at line 2:
ORA-06550: line 2, column 1:
PLS-00306: wrong number or types of arguments in call to 'CREATE_CHANGE_SET'
ORA-06550: line 2, column 1:
PL/SQL: Statement ignored

wat to do...

Thanks,
Nagaa



Re: PLS-00306: wrong number or types of arguments in call to 'CREATE_CHANGE_SET' [message #260025 is a reply to message #260022] Fri, 17 August 2007 03:19 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
The one, which you have described is a table.
I want you to describe the package DBMS_CDC_PUBLISH.

By
Vamsi
Re: PLS-00306: wrong number or types of arguments in call to 'CREATE_CHANGE_SET' [message #260036 is a reply to message #260025] Fri, 17 August 2007 04:18 Go to previous message
nagaa
Messages: 33
Registered: August 2007
Location: chennai
Member
Vamsi,

Thanks a lot......
i followed comments and do the same which refer..

But now i received different errror

SQL> ed
Wrote file afiedt.buf

1 begin
2 DBMS_CDC_PUBLISH.CREATE_CHANGE_SET(
3 SET_NAME => 'SYNC_SET',
4 CHANGE_SOURCE_NAME => 'SYNC_SOURCE',
5 BEGIN_SCN => NULL,
6 END_SCN => NULL,
7 TABLESPACE_NAME => ' ',
8 IGNORE_DDL_EVENTS => NULL,
9 ROLLBACK_SEG_NAME =>' ');
10* end;
SQL> /
begin
*
ERROR at line 1:
ORA-29540: class oracle/CDC/PublishApi does not exist
ORA-06512: at "SYS.DBMS_CDC_PUBLISH", line 298
ORA-06512: at line 2

Why this error comes?

Thanks,
Nagaa

[mod-edit] removed all illiterate IM words, possibly making it more illiterate.

[Updated on: Fri, 17 August 2007 07:58] by Moderator

Report message to a moderator

Previous Topic: UTL_FILE problem
Next Topic: How to insert new record into Table A using data from Table B (merged)
Goto Forum:
  


Current Time: Sat Dec 10 02:59:41 CST 2016

Total time taken to generate the page: 0.05094 seconds