[Home] [Help]
2591:
2592: BEGIN
2593: SELECT count(1)
2594: INTO l_rec_count
2595: FROM EGO_PUB_WS_OUTPUT
2596: WHERE SESSION_ID = l_session_id;
2597: EXCEPTION
2598: WHEN NO_DATA_FOUND THEN
2599: NULL;
2600: WHEN OTHERS THEN
2601: NULL;
2602: END;
2603: IF l_rec_count > 0 THEN
2604: UPDATE ego_pub_ws_output
2605: SET xmlcontent = l_output_xml,
2606: xml_odi = XmlType(l_xml),
2607: creation_date = sysdate
2608: WHERE session_id = l_session_id
2607: creation_date = sysdate
2608: WHERE session_id = l_session_id
2609: AND web_service_name = l_web_service_name;
2610: ELSE
2611: INSERT INTO ego_pub_ws_output (session_id,
2612: odi_session_id,
2613: web_service_name,
2614: entity_type,
2615: sequence_id,