DBA Data[Home] [Help]

APPS.BIS_PMV_UTIL dependencies on DBMS_LOB

Line 46: amount := DBMS_LOB.getlength(loc);

42: when others then
43: htp.p(SQLERRM);
44: end;
45:
46: amount := DBMS_LOB.getlength(loc);
47: -- read html codes from that location
48: while amount > maxamount
49: loop
50: DBMS_LOB.READ(loc, maxamount, offset, output);

Line 50: DBMS_LOB.READ(loc, maxamount, offset, output);

46: amount := DBMS_LOB.getlength(loc);
47: -- read html codes from that location
48: while amount > maxamount
49: loop
50: DBMS_LOB.READ(loc, maxamount, offset, output);
51: vLobPieces(vIndex) := utl_raw.cast_to_varchar2(output);
52: vIndex := vIndex + 1;
53: amount := amount - maxamount;
54: offset := offset + maxamount;

Line 58: DBMS_LOB.READ(loc, amount, offset, output);

54: offset := offset + maxamount;
55: end loop;
56:
57: if amount > 0 then
58: DBMS_LOB.READ(loc, amount, offset, output);
59: vLobPieces(vIndex) := utl_raw.cast_to_varchar2(output);
60: end if;
61:
62: return vLobPieces;