DBA Data[Home] [Help]

APPS.EGO_ITEM_TEXT_UTIL dependencies on DBMS_LOB

Line 133: DBMS_LOB.Trim ( lob_loc => x_tlob, newlen => 0 );

129:
130: IF ( p_action = 'BEGIN' ) THEN
131:
132: -- Empty the LOB, if this is the first chunk of text to append
133: DBMS_LOB.Trim ( lob_loc => x_tlob, newlen => 0 );
134:
135: g_Buffer := p_string;
136: g_Buffer_Length := -1;
137:

Line 151: DBMS_LOB.Write ( lob_loc => x_tlob

147: -- Write buffer to LOB if required
148:
149: IF ( g_Buffer_Length + l_String_Length >= l_Max_Length ) THEN
150: IF ( start_writing ) THEN
151: DBMS_LOB.Write ( lob_loc => x_tlob
152: , amount => Length (g_Buffer)
153: , offset => l_offset
154: , buffer => g_Buffer
155: );

Line 157: DBMS_LOB.WriteAppend ( lob_loc => x_tlob

153: , offset => l_offset
154: , buffer => g_Buffer
155: );
156: ELSE
157: DBMS_LOB.WriteAppend ( lob_loc => x_tlob
158: , amount => Length (g_Buffer)
159: , buffer => g_Buffer
160: );
161: END IF;

Line 174: DBMS_LOB.Write ( lob_loc => x_tlob

170:
171: IF ( p_action = 'END' ) THEN
172: start_writing := ( g_Buffer_Length = -1 );
173: IF ( start_writing ) THEN
174: DBMS_LOB.Write ( lob_loc => x_tlob
175: , amount => Length (g_Buffer)
176: , offset => l_offset
177: , buffer => g_Buffer
178: );

Line 180: DBMS_LOB.WriteAppend ( lob_loc => x_tlob

176: , offset => l_offset
177: , buffer => g_Buffer
178: );
179: ELSE
180: DBMS_LOB.WriteAppend ( lob_loc => x_tlob
181: , amount => Length (g_Buffer)
182: , buffer => g_Buffer
183: );
184: END IF;

Line 755: DBMS_LOB.Read ( lob_loc => p_tlob_loc

751: --DBMS_OUTPUT.put_line('LOB contents:');
752:
753: -- Read portions of LOB
754: LOOP
755: DBMS_LOB.Read ( lob_loc => p_tlob_loc
756: , amount => l_amount
757: , offset => l_offset
758: , buffer => l_buffer
759: );