17,086
社区成员
发帖
与我相关
我的任务
分享
SQL> create or replace procedure BMSXY_SP_CDCXY as
2 begin
3 DBMS_CDC_PUBLISH.PURGE_CHANGE_SET
4 ('CDC_SET_BMSXY','sysdate-3'
5 );
6 end;
7 /
Warning: Procedure created with compilation errors
SQL> show errors;
Errors for PROCEDURE CDC_PUBLISHER.BMSXY_SP_CDCXY:
LINE/COL ERROR
-------- ---------------------------------------------------------------------------
3/1 PLS-00306: wrong number or types of arguments in call to 'PURGE_CHANGE_SET'
3/1 PL/SQL: Statement ignored
换了一个当时创建这个变更集的用户,报错如下 怎么回事啊??求解~~~~SQL> create or replace procedure BMSXY_SP_CDCXY as
2 begin
3 DBMS_CDC_PUBLISH.PURGE_CHANGE_SET
4 ('CDC_SET_BMSXY','sysdate-3'
5 );
6 end;
7 /
Warning: Procedure created with compilation errors
SQL> show errors;
Errors for PROCEDURE BMSXY_CDC_CONF.BMSXY_SP_CDCXY:
LINE/COL ERROR
-------- ---------------------------------------------------------
3/1 PLS-00201: identifier 'DBMS_CDC_PUBLISH' must be declared
3/1 PL/SQL: Statement ignored
这样的
-- show errors 一下,看看什么错误
SQL>
SQL> create or replace procedure BMSXY_SP_CDCXY as
2 begin
3 DBMS_CDC_PUBLISH.PURGE_CHANGE_SET
4
5 ('CDC_SET_BMSXY','sysdate-3'
6 );
7 end;
8 /
Warning: Procedure created with compilation errors
SQL> show errors;
Errors for PROCEDURE XSNWSH_USER.BMSXY_SP_CDCXY:
LINE/COL ERROR
-------- --------------------------------------------
3/2 PLS-00201: 必须声明标识符 'DBMS_CDC_PUBLISH'
3/2 PL/SQL: Statement ignored
SQL>