Line 78: SELECT TO_CHAR(SYSDATE,'DD-MM-YYY:HH24-MI-SS') INTO date_time FROM DUAL;
74: RAISE INVALID_TP_SETUP;
75: END IF;
76:
77: -- Fetching date_time to pass as BES_EVENT_KEY 78: SELECT TO_CHAR(SYSDATE,'DD-MM-YYY:HH24-MI-SS') INTO date_time FROM DUAL; 79: SELECT SUBSTR(ADDRESS,INSTR(ADDRESS,'.',1,1)+1) INTO agent_name FROM WF_AGENTS WHERE NAME = 'WF_WS_JMS_IN';
80:
81: R_ECX_HEADER := sys.AQ$_JMS_HEADER(NULL, NULL, NULL, NULL, NULL, NULL,
82: sys.AQ$_JMS_USERPROPARRAY(
[Home] [Help]