使用PL/SQL从数据库中读取BLOB对象

SQL> col fdesc for a30
SQL> select fid,fname,fdesc from eygle_blob;
       FID FNAME                                              FDESC
---------- -------------------------------------------------- ------------------------------
         1 ShaoLin.jpg                                        少林寺-康熙手书
         2 DaoYing.jpg                                        倒映

SQL> connect / as sysdba
Connected.
SQL> create or replace directory BLOBDIR as 'D:\\oradata\\Pic';
Directory created.
SQL>
SQL> grant read,write on directory BLOBDIR to eygle;
Grant succeeded.
SQL>