SQL> drop table IMAGE_LOB;
表已丢弃。
SQL> CREATE TABLE IMAGE_LOB ( 2 T_ID VARCHAR2 (5) NOT NULL, 3 T_IMAGE BLOB NOT NULL 4 );
表已创建。
SQL> CREATE OR REPLACE DIRECTORY IMAGES AS 'C:/Inetpub/wwwroot';
目录已创建。
SQL> CREATE OR REPLACE PROCEDURE IMG_INSERT ( 2 TID VARCHAR2, 3 FILENAME VARCHAR2) AS 4 F_LOB BFILE; 5 B_LOB BLOB; 6 BEGIN 7 INSERT INTO IMAGE_LOB (T_ID, T_IMAGE) VALUES (TID, 8 EMPTY_BLOB ()) RETURN T_IMAGE INTO B......
阅读全文