测试开始
SQL> create or replace directory dir1 as '/tmp/';
Directory created.
SQL> create or replace directory "dir2" as '/tmp/';
Directory created.
SQL> show user;
USER is "SYS"
SQL>
会话1:将一些数据加载到BLOB或者CLOB中
SQL> create table demo
2 (id int primary key,
3 theClob clob
4 )
5 /
Table created.
SQL> host echo 'Hello World!'>/tmp/test.txt
SQL> declare
2 l_clob clob;
3 l_bfile bfile;
4 begin
5 insert into demo values(1,empty_clob())
6 returning theclob into l_clob;
7 l_bfile:=bfilename('DIR1','test.txt');
8 dbms_lob.fileopen(l_bfile);
9 dbms_lob.loadfromfile(l_clob,l_bfile,dbms_lob.getlength(l_bfile));
10 dbms_lob.fileclose(l_bfile);
11 end;
12 /
PL/SQL procedure successfully completed.
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/15720542/viewspace-723538/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/15720542/viewspace-723538/