Setup Of Downstream Capture Fails With Ora-06550 Pls-00306 (Doc ID 1297810.1)

Last updated on SEPTEMBER 07, 2015

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2 and later
Information in this document applies to any platform.

Symptoms

When configuring a downstream capture process in 11.2.0.2.1 database from 11.2.0.1 database (source) , process always fail PLS-00306.

Source: 11.2.0.1
Downstream: 11.2.0.2

SQL> BEGIN
DBMS_CAPTURE_ADM.CREATE_CAPTURE(
queue_name => 'streams_queue',
capture_name => 'downstream_capture',
rule_set_name => NULL,
start_scn => NULL,
source_database => 'STRM112Q.US.<use_database_link => true,
first_scn => NULL,
logfile_assignment => 'implicit');
END;
/ 2 3 4 5 6 7 8 9 10 11 12
BEGIN
*
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'BUILD_RC'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
ORA-06512: at "SYS.DBMS_CAPTURE_ADM_INTERNAL", line 453
ORA-06512: at "SYS.DBMS_CAPTURE_ADM", line 289
ORA-06512: at line 2

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms