EBS Customizations (MOSC)

MOSC Banner

Can you return an CLOB in EBS Integrated SOA Gateway?

I need to be able to return a nested XML block via PL/SQL.

For example, if I may need to return all the functions of a group of existing ISG PL/SQL classes.

I can use the following SQL to generate the nested XML.  Is it possible to return this in the EBS ISG?

SELECT XMLSERIALIZE(CONTENT

  XMLELEMENT("Classes", XMLAGG(

    XMLELEMENT("Class",

      XMLFOREST (

        C.CLASS_ID "ClassID"

        , C.CLASS_NAME "ClassName"

        , C.PRODUCT_CODE "ProductCode"

      ), /* end class forest */

    XMLELEMENT("Functions",

      (SELECT XMLAGG(

        XMLELEMENT("Function",

          XMLFOREST (

            F.FUNCTION_ID "FunctionID"

            , F.FUNCTION_NAME "FunctionName"

          ) /* end functions foreest */

        ) /* end function element */

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center