222:
223: BEGIN
224: IF (nvl(lengthb(sv),0) + nvl(lengthb(vl),0)) >= 32000 THEN
225: len := nvl(lengthb(sv),0);
226: dbms_lob.writeappend(cl,len,sv);
227: sv := vl;
228: ELSE
229: sv := sv || vl;
230: END IF;
346: END LOOP;
347: END LOOP;
348: --Bug 12665166
349: --Before appending stvar to site_lob, verifying length of stvar
350: --dbms_lob.writeappend(site_lob,lengthb(stvar),stvar);
351: IF length(stvar) <> 0 THEN
352: dbms_lob.writeappend(site_lob,nvl(length(stvar),0),stvar) ;
353: END IF;
354: END;
348: --Bug 12665166
349: --Before appending stvar to site_lob, verifying length of stvar
350: --dbms_lob.writeappend(site_lob,lengthb(stvar),stvar);
351: IF length(stvar) <> 0 THEN
352: dbms_lob.writeappend(site_lob,nvl(length(stvar),0),stvar) ;
353: END IF;
354: END;
355:
356: Procedure site_info (