I want to Transfer the Data from Source Oracle to Destination Oracle.
In data one Column have XMLTYPE, while transfer the data am getting below error.
[statistics] connecting to socket on port 4052
ORA-06553: PLS-306: wrong number or types of arguments in call to 'XMLTYPE'.
tInputOracle --> tOutputOracle.
Kindly help me. I want to tansfer 2 Million data from one schema to another schema.
What does your input query look like? Are you using EXTRACTVALUE() EXTRACT() in it?