扫一扫
分享文章到微信
扫一扫
关注官方公众号
至顶头条
在本页阅读全文(共2页)
CREATE TABLE [table_name] ( NAME VARCHAR2(256) UNIQUE NOT NULL, MIME_TYPE VARCHAR2(128), DOC_SIZE NUMBER, DAD_CHARSET VARCHAR2(128), LAST_UPDATED DATE, CONTENT_TYPE VARCHAR2(128), [content_column_name] [content_column_type] [ , [content_column_name] [content_column_type]] ); |
NAME VARCHAR(128) UNIQUE NOT NULL, MIME_TYPE VARCHAR(128), DOC_SIZE NUMBER, DAD_CHARSET VARCHAR(128), LAST_UPDATED DATE, CONTENT_TYPE VARCHAR(128), CONTENT LONG RAW, BLOB_CONTENT BLOB ; |
CREATE OR REPLACE PROCEDURE "ZYFILEUP"."IN_FILE" is begin htp.prn(' <html> <head> <title>File upload</title> </head> <body bgcolor="#C0C0C0"> <form enctype="multipart/form-data" action="/pls/upfile/write_infos" method="POST"> <p><b><font size="5" color="#800080">指定上载文件</font></b></p> <hr> <p> <b>标题:<textarea rows="3" name="filetitle" cols="100" style="background-color: #008080; color: #FFFFFF"></textarea> <br> <b>类别:<input type="text" name="filesort" size="130" style="background-color: #008080; color: #FFFFFF"> <br> <b>作者:<input type="text" name="author" size="130" style="background-color: #008080; color: #FFFFFF"> <br> <b>小类:<input type="text" name="localsort" size="130" style="background-color: #008080; color: #FFFFFF"> <br> <b>摘要:<textarea rows="5" name="abstract" cols="130" style="background-color: #008080; color: #FFFFFF"></textarea> <br> <b>文章1:<input type="file" name="up_file" size="110" style="background-color: #008080; color: #FFFFFF"> <br> <b>文章2:<input type="file" name="up_file" size="110" style="background-color: #008080; color: #FFFFFF"> <br> <b>文章3:<input type="file" name="up_file" size="110" style="background-color: #008080; color: #FFFFFF"> <br> <b>文章4:<input type="file" name="up_file" size="110" style="background-color: #008080; color: #FFFFFF"> <br> </b></b></b></b></b></b></b></b></b></b> </p><hr><p><b> <line> <input type="submit" value="提交"> <input type="reset" value="全部重写"> </p> </form> </body> </html> '); end; |
CREATE OR REPLACE PROCEDURE "ZYFILEUP"."WRITE_INFOS" ( filetitle in varchar2, up_file in owa.vc_arr, filesort in varchar2, author in varchar2, abstract in varchar2, localsort in varchar2 ) is i number:=1; begin htp.htmlopen; htp.headopen; htp.title('File Uploaded'); htp.headclose; htp.bodyopen; htp.header(1, 'Upload Status'); while true loop begin htp.prn('Uploaded '|| up_file(i) ||' successfully !'); htp.prn('<br>'); htp.prn('<a href="/pls/upfile/downfile?upfilename='); htp.prn(utl_url.escape(up_file(i),true,'GBK')); htp.prn('" target="_blank">Open this file !</a>'); htp.prn('<br>'); INSERT INTO "ZYFILEUP"."FILE_TABLE" values(filetitle,up_file(i),filesort,author,sysdate(),abstract,localsort); commit; i:=i+1; exception when no_data_found then exit; end; end loop; htp.line; htp.print('Uploaded successfully !'); htp.bodyclose; htp.htmlclose; end; |
CREATE OR REPLACE PROCEDURE "ZYFILEUP"."DOWNFILE" (upfilename in varchar2) is mimetype varchar2(100); myblob blob; begin select mime_type,blob_content into mimetype,myblob from zyfileup.content_table where name = upfilename; owa_util.mime_header(mimetype, true); sys.wpg_docload.download_file(myblob); end; |
如果您非常迫切的想了解IT领域最新产品与技术信息,那么订阅至顶网技术邮件将是您的最佳途径之一。