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 */