新建目录出问题,请教
create or replace directory utllobdir as 'C:\DDS\EXTPROC';
我在做
set serveroutput on
declare
a_clob clob;
a_bfile bfile:=bfilename('utllobdir','longyuan.doc');
begin
insert into manager.bfile_tab values(a_bfile)
returning bfile_column into a_bfile;
insert into manager.utl_lob_test values (empty_clob())
returning blob_column into a_clob;
dbms_lob.fileopen(a_bfile);
dbms_lob.loadfromfile(a_clob,a_bfile,dbms_lob.getlength(a_bfile));
dbms_lob.fileclose(a_bfile);
commit;
end;
提示:
ORA-22285: 对不存在的目录或文件进行FILEOPEN操作
ORA-06512: 在"SYS.DBMS_LOB", line 504
已经给manager用户授权了,请问是怎么回事