3034: RETURN;
3035: END IF;
3036:
3037: l_inputFilePtr := BFILENAME('INPUTDIR', p_file_name);
3038: dbms_lob.open(l_inputFilePtr, dbms_lob.lob_readonly);
3039:
3040: dbms_lob.createtemporary(l_contentBlob,TRUE);
3041: dbms_lob.open(l_contentBlob,dbms_lob.lob_readWrite);
3042: dbms_lob.loadfromfile(l_contentBlob,l_inputFilePtr,dbms_lob.getlength(l_inputFilePtr));
3036:
3037: l_inputFilePtr := BFILENAME('INPUTDIR', p_file_name);
3038: dbms_lob.open(l_inputFilePtr, dbms_lob.lob_readonly);
3039:
3040: dbms_lob.createtemporary(l_contentBlob,TRUE);
3041: dbms_lob.open(l_contentBlob,dbms_lob.lob_readWrite);
3042: dbms_lob.loadfromfile(l_contentBlob,l_inputFilePtr,dbms_lob.getlength(l_inputFilePtr));
3043:
3044: dbms_lob.fileclose(l_inputFilePtr);
3037: l_inputFilePtr := BFILENAME('INPUTDIR', p_file_name);
3038: dbms_lob.open(l_inputFilePtr, dbms_lob.lob_readonly);
3039:
3040: dbms_lob.createtemporary(l_contentBlob,TRUE);
3041: dbms_lob.open(l_contentBlob,dbms_lob.lob_readWrite);
3042: dbms_lob.loadfromfile(l_contentBlob,l_inputFilePtr,dbms_lob.getlength(l_inputFilePtr));
3043:
3044: dbms_lob.fileclose(l_inputFilePtr);
3045: dbms_lob.close(l_contentBlob);
3038: dbms_lob.open(l_inputFilePtr, dbms_lob.lob_readonly);
3039:
3040: dbms_lob.createtemporary(l_contentBlob,TRUE);
3041: dbms_lob.open(l_contentBlob,dbms_lob.lob_readWrite);
3042: dbms_lob.loadfromfile(l_contentBlob,l_inputFilePtr,dbms_lob.getlength(l_inputFilePtr));
3043:
3044: dbms_lob.fileclose(l_inputFilePtr);
3045: dbms_lob.close(l_contentBlob);
3046:
3040: dbms_lob.createtemporary(l_contentBlob,TRUE);
3041: dbms_lob.open(l_contentBlob,dbms_lob.lob_readWrite);
3042: dbms_lob.loadfromfile(l_contentBlob,l_inputFilePtr,dbms_lob.getlength(l_inputFilePtr));
3043:
3044: dbms_lob.fileclose(l_inputFilePtr);
3045: dbms_lob.close(l_contentBlob);
3046:
3047: select fnd_lobs_s.nextval into seqNo from dual;
3048:
3041: dbms_lob.open(l_contentBlob,dbms_lob.lob_readWrite);
3042: dbms_lob.loadfromfile(l_contentBlob,l_inputFilePtr,dbms_lob.getlength(l_inputFilePtr));
3043:
3044: dbms_lob.fileclose(l_inputFilePtr);
3045: dbms_lob.close(l_contentBlob);
3046:
3047: select fnd_lobs_s.nextval into seqNo from dual;
3048:
3049: insert into fnd_lobs(