I am facing a new issue whenever i create a new database. XMLCONCAT function is not working. Its giving the following error. This function exists in sys.
select xmlconcat(xmlelement(eln,1)) from dual;
ORA-06553: PLS-306: wrong number or types of arguments in call to 'XMLCONCAT'
This is not related to wrong number or argument. Somehow i solved this in one of my instance but i dont remember how i did that.
Any help from experts?