Search code examples
oracleoracle11goracle-xeoracle-cdc

identifier 'DBMS_CDC_PUBLISH.CREATE_CHANGE_SET' must be declared

I am using oracle 11g express edition and I am getting the below error when trying to create a change set.

Error report -

ORA-06550: line 2, column 3:

PLS-00201: identifier 'DBMS_CDC_PUBLISH.CREATE_CHANGE_SET' must be declared

ORA-06550: line 2, column 3:

PL/SQL: Statement ignored

06550. 00000 -  "line %s, column %s:\n%s"

*Cause:    Usually a PL/SQL compilation error.

*Action:

I know CDC is desupported in later versions of oracle but I think it is supported here.

Can anyone help please/

Thanks in advance!

Solution

  • The problem is that you are using Express Edition, which does not include Change Data Capture functionality.