SYS.WPG_DOCLOAD dependencies on DBMS_LOB

Line 77: dbms_lob.fileopen(p_bfile);

73: dir_alias VARCHAR2(30) := NULL;
74: fname VARCHAR2(2000) := NULL;
75: len pls_integer;
76: BEGIN
77: dbms_lob.fileopen(p_bfile);
78: v_bfile := p_bfile;
79: v_blob := NULL;
80: v_filename := NULL;
81: v_bcaching := NULL;

Line 130: RETURN dbms_lob.getlength(v_blob);

126: IS
127: BEGIN
128: IF (v_blob IS NOT NULL)
129: THEN
130: RETURN dbms_lob.getlength(v_blob);
131: ELSIF (v_bfile IS NOT NULL)
132: THEN
133: RETURN dbms_lob.getlength(v_bfile);
134: ELSE

Line 133: RETURN dbms_lob.getlength(v_bfile);

129: THEN
130: RETURN dbms_lob.getlength(v_blob);
131: ELSIF (v_bfile IS NOT NULL)
132: THEN
133: RETURN dbms_lob.getlength(v_bfile);
134: ELSE
135: RETURN NULL;
136: END IF;
137: END;

Line 151: IF dbms_lob.istemporary(v_blob) = 1 THEN

147: PROCEDURE get_download_blob(p_blob OUT NOCOPY blob)
148: IS
149: BEGIN
150: p_blob := v_blob;
151: IF dbms_lob.istemporary(v_blob) = 1 THEN
152: dbms_lob.freetemporary(v_blob);
153: END IF;
154: v_blob := NULL;
155: END;

Line 152: dbms_lob.freetemporary(v_blob);

148: IS
149: BEGIN
150: p_blob := v_blob;
151: IF dbms_lob.istemporary(v_blob) = 1 THEN
152: dbms_lob.freetemporary(v_blob);
153: END IF;
154: v_blob := NULL;
155: END;
156: