W
weilai2570019
Unregistered / Unconfirmed
GUEST, unregistred user!
asp.net2.0如何从另外一台机器拿出自己想要的图片在一网页中显示
下面是orcale的存储过程它能返回什么呀是路径么
procedure GetPhotoByXH(axh varchar2,rst out sys_refcursor) is
dir varchar2(100);
filename varchar2(1000);
begin
select tjtp,qmtp into dir,filename from cltx t where xh=axh;
open rst for select GetVideo(filename,dir) photo from dual;
end GetPhotoByXH;
function GetVideo(aFileName varchar2,aDir varchar2) return blob is
m_File bfile;
m_Lob blob;
len integer;
begin
m_File:=bfilename(aDir,aFileName);
dbms_lob.createtemporary(m_Lob,true);
dbms_lob.fileopen(m_File);
len:=dbms_lob.getlength(m_file);
dbms_lob.loadfromfile(m_Lob,m_file,len);
dbms_lob.fileclose(m_File);
return m_Lob;
end;
在.net2.0中运行上面的包后就谈出下面的错误提示
ORA-22288: 文件或 LOB 操作FILEOPEN失败
系统找不到指定的路径。
ORA-06512: 在"SYS.DBMS_LOB", line 504
ORA-06512: 在"ZAKK.PKG_KEPWEB_PECCANCY", line 47
下面是orcale的存储过程它能返回什么呀是路径么
procedure GetPhotoByXH(axh varchar2,rst out sys_refcursor) is
dir varchar2(100);
filename varchar2(1000);
begin
select tjtp,qmtp into dir,filename from cltx t where xh=axh;
open rst for select GetVideo(filename,dir) photo from dual;
end GetPhotoByXH;
function GetVideo(aFileName varchar2,aDir varchar2) return blob is
m_File bfile;
m_Lob blob;
len integer;
begin
m_File:=bfilename(aDir,aFileName);
dbms_lob.createtemporary(m_Lob,true);
dbms_lob.fileopen(m_File);
len:=dbms_lob.getlength(m_file);
dbms_lob.loadfromfile(m_Lob,m_file,len);
dbms_lob.fileclose(m_File);
return m_Lob;
end;
在.net2.0中运行上面的包后就谈出下面的错误提示
ORA-22288: 文件或 LOB 操作FILEOPEN失败
系统找不到指定的路径。
ORA-06512: 在"SYS.DBMS_LOB", line 504
ORA-06512: 在"ZAKK.PKG_KEPWEB_PECCANCY", line 47