oracle 字段类型问题 100分

[Delphist]

我想在oracle中
1.存一个文件，该用什么字段，
2.怎么存
谢谢

[jiezhi]

oh,the same question?

[jiezhi]

怎么两个人的问题相同？
blob
bfile
you can see faq or look up oracle document:
Oracle8i Application Developer's Guide - Large Objects (LOBs)
url:http://gwynne.cs.ualberta.ca/~oracle/817doc/products.htm

[penitent]

oracle建议用lob类型，还可以用long类型
--------------------
如果发现重贴的问题。可能要删除你的帖子，最好不要开重贴。

[zhx_232]

blob或者clob

[IVANY]

建议用blob,我一般都用blob

[yuxuan]

用Blob比用Long类型好

[追梦]

呵呵

[more_zou]

CREATE OR REPLACE PROCEDURE insert_photo
(p_rno NUMBER, p_photo VARCHAR2)
AS
f_photo BFILE;
b_photo BLOB;
Begin

-- Update the employee photo
insert into blob_test values (p_rno,empty_blob())
RETURN picture into b_photo;

-- find where the photo's pointer is located.
f_photo := bfilename('IMAGE', p_photo);
-- open the photo as read-only option.
dbms_lob.fileopen(f_photo, dbms_lob.file_readonly);
-- load the photo into column photo.
dbms_lob.loadfromfile(b_photo,f_photo, dbms_lob.getlength(f_photo));
-- close the photo's pointer.
dbms_lob.fileclose(f_photo);
-- Save the loaded photo record.
COMMIT;
EXCEPTION
-- Check for your error messages
WHEN others THEN
dbms_output.put_line('*** ERROR *** Check you procedure.');
END;
/

[Delphist]

是我同学害我啊