先用你的前台开发语言打开文件,读入文件内容到一个二进制的变量中
UPDATEBLOB 表名 SET 列名= :lb_syntax WHERE 条件;
lb_syntax是你文档内容的二进制的变量,
就是
fileopen()
read()
fileclose
updateblob
ok!
UPDATEBLOB 表名 SET 列名= :lb_syntax WHERE 条件;
lb_syntax是你文档内容的二进制的变量,
就是
fileopen()
read()
fileclose
updateblob
ok!
数据库用pl/sql编程
create table t(no number,file blob);create or replace directory WORDDIR as 'dir to file';CREATE OR REPLACE PROCEDURE insert_file
(p_rno NUMBER, p_file VARCHAR2)
AS
f_file BFILE;
b_file BLOB;
Begininsert into t values (p_rno,empty_blob())
RETURN file into b_file;f_photo := bfilename('WORDDIR', p_file);dbms_lob.fileopen(f_file, dbms_lob.file_readonly);dbms_lob.loadfromfile(b_file,f_file, dbms_lob.getlength(f_file));dbms_lob.fileclose(f_file);COMMIT;
EXCEPTION
-- Check for your error messages
WHEN others THEN
dbms_output.put_line('*** ERROR *** Check you procedure.');
END;
用dbms_output.put_line