CREATE TABLE tb_photo
(
id VARCHAR2(64),
photo BLOB
)
create or replace directory "images" as 'd:\pic\';
CREATE OR REPLACE PROCEDURE IMG_INSERT(ID VARCHAR2, FILENAME VARCHAR2) AS
F_LOB BFILE;
B_LOB BLOB;
BEGIN
INSERT INTO TB_PHOTO
(ID, PHOTO)
VALUES
(ID, EMPTY_BLOB()) RETURN PHOTO INTO B_LOB;
F_LOB := BFILENAME('images', FILENAME);
DBMS_LOB.FILEOPEN(F_LOB, DBMS_LOB.FILE_READONLY);
DBMS_LOB.LOADFROMFILE(B_LOB, F_LOB, DBMS_LOB.GETLENGTH(F_LOB));
DBMS_LOB.FILECLOSE(F_LOB);
COMMIT;
END;
CALL img_insert('123456','aa.png');
SELECT * FROM tb_photo;
oracle存储图片
最新推荐文章于 2021-09-03 15:33:31 发布