PLS-00201: "identifier 'XMLCONCAT' must be declared" Using XMLConcat in PL/SQL (Doc ID 1434853.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.5 and later   [Release: 10.2 and later ]
Information in this document applies to any platform.

Symptoms


  • Compiling a package that was working in Oracle Database 9i is failing after upgrade to 10g or higher

  • This is part of the code:

    ...
    XML_RETURN := XMLCONCAT(XMLSEQUENCETYPE(XML_RETURN, XML_TMP));
    ...
  • The error received is:

    PLS-00201: identifier 'XMLCONCAT' must be declared


Changes

Upgrade from Oracle Database 9i to 10g or higher.

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