求高人帮忙,我自己写的一个过程,它总是提示编译错误
在oracle9i 的sql plus中编译的,是一个向数据库中重复插入图片的procedure,但是总提示编译错误,哪位帮帮忙啊,先谢谢了代码如下:
create table image_lob(T_ID VARCHAR2 (5) NOT NULL,T_IMAGE BLOB NOT NULL);
CREATE OR REPLACE DIRECTORY IMAGES AS 'C:\Oracle';
Create or replace procedure img_insert(T_amount1 number ,T_amount2 number) as
F_lob bfile;
B_lob blob;
Temp varchar2;
Temp2 varchar2;
Begin
Temp:=”user”;
Temp2:=”.jpg”;
Loop
If n_amount1>n_amount2 then
Exit;
End if;
INSERT INTO IMAGE_LOB (T_ID, T_IMAGE)
Values(T_amount1,empty_blob()) return T_IMAGE into B_lob;
F_LOB:= BFILENAME ('IMAGES', temp.concat(n_amount1,temp2));
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;
N_amount1:=n_amount1+1;
End loop;
End;
程序所用到的图片是以user1,user2,....命名的,