Hi

while trying to execute a procedure i am getting error as
“ORA-22290: operation would exceed the maximum number of opened files or LOBs
ORA-06512: at "SYS.DBMS_LOB", line 523
ORA-06512: at "SYS.XMLTYPE", line 281
ORA-06512: at line 1
ORA-06512: at "PDS.UPLOAD_LOGIC", line 117
ORA-06512: at line 1”

The code of procedure is as follows:
CREATE OR REPLACE PROCEDURE upload_logic (
v_logic_type IN VARCHAR2,
v_description IN VARCHAR2,
v_MAP IN VARCHAR2
)
AS
v_dl_path pds.logic_map.actual_type%TYPE;
v_oxl_type pds.logic_map.actual_type%TYPE;
v_file_id vision.dlr_file.file_id%TYPE;
v_version_minor vision.dlr_meta_data.version_minor%TYPE;
v_version_major vision.dlr_meta_data.version_major%TYPE;
v_deployment_date vision.dlr_meta_data.deployment_date%TYPE;
v_version_id vision.dlr_meta_data.version_id%TYPE;
/*v_blob BLOB;
v_raw Long Raw;
v_len_pic NUMBER (38);
v_dest_offset NUMBER (38) := 1;
v_src_offset NUMBER (38) := 1;
v_pic bfile;*/
BEGIN

-- THIS IS USED TO GET THE ACTUAL TREE PATH WHERE THE LOGIC NEEDS TO BE DEPLOYED
SELECT actual_type,substr(actual_type,instr(actual_type,'/',1,3)+1,length(actual_type))
INTO v_dl_path,v_oxl_type
FROM pds.logic_map
WHERE logic_type = v_logic_type;

-- FILED_ID OF THE ACTUAL PATH IS EXTRACTED
SELECT file_id
INTO v_file_id
FROM vision.dlr_file
WHERE PATH = v_dl_path AND file_type = 'F';


--VERSION NUMBER ARE BEING EXTRACTED HERE.
SELECT MAX (version_minor)
INTO v_version_minor
FROM vision.dlr_meta_data
WHERE file_id = v_file_id
GROUP BY version_major
HAVING version_major = MAX (version_major);

DBMS_OUTPUT.put_line ('V_VERSION_MINOR====>'||V_VERSION_MINOR);

SELECT MAX (version_major)
INTO v_version_major
FROM vision.dlr_meta_data
WHERE file_id = v_file_id;

DBMS_OUTPUT.put_line ('V_VERSION_MAJOR====>'||V_VERSION_MAJOR);


IF v_version_minor = 99
THEN
v_version_minor := 01;
v_version_major := v_version_major + 1;
else
v_version_minor := v_version_minor+1;
END IF;

-- DEPLOYMENT DAYE
SELECT ((SYSDATE - TO_DATE ('01-01-1970', 'dd-mm-yyyy')) * 86400000) - (330*60*1000)
INTO v_deployment_date
FROM DUAL;
DBMS_OUTPUT.put_line ('V_DEPLOYMENT_DATE====>'||V_DEPLOYMENT_DATE);

INSERT INTO vision.dlr_meta_data
VALUES (vision.dlr_hibernate_seq.NEXTVAL, v_file_id, v_version_major,
v_version_minor, v_deployment_date, v_description, 'rashesh');


SELECT version_id
INTO v_version_id
FROM vision.dlr_meta_data
WHERE file_id = v_file_id
AND version_major = v_version_major
AND version_minor = v_version_minor
AND deployment_date = v_deployment_date;

DBMS_OUTPUT.put_line ('V_VERSION_ID====>'||V_VERSION_ID);

-- INSERTION OF LOGIC INTO DLR_CONTENT TABLE

INSERT INTO vision.dlr_content
VALUES (vision.dlr_hibernate_seq.NEXTVAL, v_version_id, rawtohex(xmltype(bfilename('DM_PMML_DIR','account-assessment.oxl'),nls_charset_id('AL332UTF8'))));

DBMS_OUTPUT.put_line ('uploading done');

commit;

--Mapping
IF V_MAP = 'MAP'
THEN
maplogic (V_LOGIC_TYPE,v_version_id,v_file_id,v_version_mAJor||'.'||v_version_minor);
else
dbms_output.put_line('logic uploaded in to the repository but not mapped to this version');
END IF;



END upload_logic;
/

It is at above Red highlighted line the error is coming up.

Thanks in advance.