oracle dbms解密后乱码,dbms_lob出现乱码

创建目录

create or replace directory  dir1 as '/export/home1/oracle/test';

create table testload(

name  varchar2(22) primary key,

object clob)

装载脚本

declare

l_clob clob;

l_bfile bfile;

amt number:=dbms_lob.lobmaxsize;

src_offset number :=1;

dst_offset number :=1;

charset  varchar2(32);

charsetid number;

lang_ctx number :=dbms_lob.default_lang_ctx;

warning number;

begin

select value into charset from v$nls_parameters where parameter='NLS_CHARACTERSET';

select nls_charset_id(charset)   into charsetid   from dual;

insert into testload values('test1',empty_clob()) returning object into l_clob;

l_bfile:=bfilename('DIR1','11.txt');

dbms_lob.fileopen(l_bfile);

dbms_lob.loadclobfromfile(l_clob,l_bfile,amt,dst_offset,src_offset,charsetid,lang_ctx,warning);

dbms_lob.fileclose(l_bfile);

commit;

end;

详细见一篇文章

http://logzgh.itpub.net/post/3185/22312