DBA Data[Home] [Help]

APPS.XNB_QUEUE_HANDLERS_PKG dependencies on DBMS_LOB

Line 101: l_payload_length := dbms_lob.getlength(l_ecx_message.payload);

97: -- Find out the length of the message
98: --
99: -------------------------------------------------------------------------------------
100:
101: l_payload_length := dbms_lob.getlength(l_ecx_message.payload);
102:
103: -------------------------------------------------------------------------------------
104: -- If the length of the message is more than 4000 it has to be represented
105: -- as a CLOB in the JMS message otherwise as a VARCHAR

Line 115: DBMS_LOB.READ(l_ecx_message.payload, l_payload_length, 1, l_payload_vc);

111: l_jms_message.SET_TEXT(l_ecx_message.payload);
112:
113: ELSE
114:
115: DBMS_LOB.READ(l_ecx_message.payload, l_payload_length, 1, l_payload_vc);
116: l_jms_message.SET_TEXT(l_payload_vc);
117:
118: END IF;
119: