[Home] [Help]
5122:
5123:
5124:
5125:
5126: --This function reads the ODI output XML from table EGO_PUB_WS_OUTPUT using
5127: --the provided session_id and transforms it using the XSL information stored
5128: --in table EGO_ODI_WS_XSL and pointed by the web service name specified.
5129: --The function returns the transformed XML into a clob variable.
5130: FUNCTION Transform_XML(p_xml_input IN CLOB,
5182:
5183: --Generates an XML payload containg the results of executing a given web service
5184: --from the data stored by the service scenario execution in table EGO_PUB_WS_FLAT_RECS.
5185: --The resulting XML payload is stored in column XMLCONTENT
5186: --of table EGO_PUB_WS_OUTPUT
5187: PROCEDURE Generate_XML(p_session_id IN NUMBER,
5188: p_odi_session_id IN NUMBER,
5189: p_web_service_name IN VARCHAR2,
5190: p_xml_root_element IN VARCHAR2,
5585: -- Write final XML payload to output table in XML TYPE column
5586: -- with sequence id as zero
5587: -- This payload will be accessed using serviceutil.java with sequence_id
5588: -- as zero for return_payload as TRUE
5589: INSERT INTO ego_pub_ws_output (session_id,
5590: odi_session_id,
5591: web_service_name,
5592: sequence_id,
5593: xmlcontent,
5728:
5729:
5730: -- Write XML payload to output table for each top level entity with
5731: -- sequence_id.
5732: INSERT INTO ego_pub_ws_output (session_id, odi_session_id, web_service_name, sequence_id, xmlcontent, xml_odi, creation_date, created_by)
5733: VALUES (l_session_id, p_odi_session_id, p_web_service_name, l_sequence, l_output_xml, xmltype (l_xml), SYSDATE, 0);
5734:
5735: --Re-Initialize all variable
5736: l_xml := NULL;
5861: -- Insert final data in to output table with sequence_id as zero, This
5862: -- will contain session_id and entity_count, End user will use this data
5863: -- to get detail about no of entity for a session, It will use this detail
5864: -- to get data from database view provided to them
5865: INSERT INTO EGO_PUB_WS_OUTPUT (session_id,
5866: odi_session_id,
5867: web_service_name,
5868: sequence_id,
5869: xmlcontent,
5885:
5886:
5887:
5888: --Insert XML as string for debugging
5889: --INSERT INTO EGO_PUB_WS_OUTPUT (session_id,
5890: -- odi_session_id,
5891: -- web_service_name,
5892: -- XMLCLOB,
5893: -- creation_date,