ÏòORACLEÖÐÉÏ´«Îļþcreate directory×ÜÊdzö´í

ÏÖÔÚÒªÏòOracleÖÐÉÏ´«Ò»¸öÎļþ£¬´úÂëÈçÏ£º
create or replace function plan_fliles_load_file
      (filePath varchar2,fileName varchar2) return boolean
/* *******************************************************************************************
--¹¦    ÄÜ£ºÏò±íÖÐÉÏ´«Îļþ
--ÊäÈë²ÎÊý£º
  fileName£ºÒªÉÏ´«µÄÎļþÃû³Æ, filePath£º±¾Îļþȫ·¾¶
--Êä³ö²ÎÊý: ÉÏ´«ÎļþÊÇ·ñ³É¹¦                 
--********************************************************************************************/
AS
    Result BOOLEAN;
    F_LOB BFILE;
    B_LOB BLOB;
    bfile_path varchar2;
 
begin
    INSERT INTO plan_files(filename,filecontent)
      valueS(fileName,EMPTY_BLOB())RETURN filecontent INTO B_LOB;
    create directory bfile_path as filePath;
 
    F_LOB:= BFILENAME (bfile_path, FILENAME);
       
  return(Result);
end plan_fliles_load_file;

Ϊʲôcreate directory bfile_path as filePath;Õâ¾äÀϳö´í£¬´ó¼Ò°ïÎÒÐÞ¸ÄÐ޸ģ¬ºÃ³¤Ê±¼ä¶¼½â¾ö²»ÁË£¬¼±¼±¼±¡£Ð»Ð»

---

ÒýÓÃ

ÏÖÔÚÒªÏòOracleÖÐÉÏ´«Ò»¸öÎļþ£¬´úÂëÈçÏ£º
create or replace function plan_fliles_load_file
      (filePath v