-
select
-
xmlelement("ICsoaJMS:ErrorNotification",
-
xmlattributes(g_out_ns as "xmlns:ICsoaJMS"),
-
xmlelement("ICsoaJMS:PhaseID", l_phaseID),
-
xmlelement("ICsoaJMS:OrigQueue", l_originatingSubs(l_cur).queue_name),
-
xmlelement("ICsoaJMS:ResubmitID", message_handle)
-
)
-
into l_errorNotificationMessage
-
from dual;
-
-
SELECT appendchildxml(
-
l_errorNotificationMessage,
-
'/ICsoaJMS:ErrorNotification',
-
l_errorMessageStruct(l_phaseID),
-
'xmlns:ICsoaJMS="' || g_out_ns || '"'
-
)
-
INTO l_errorNotificationMessage
-
FROM dual;
Variable element name
-
select xmlelement(evalname('aaa'))
-
from dual;
Output XMLTYPE
-
dbms_output.put_line(l_xmlres.getCLOBVal());
RJM Article Type
Work Notes