READ

读取LOB数据

声明

DBMS_LOB.READ (
   lob_loc   IN             BLOB,
   amount    IN OUT  NOCOPY INTEGER,
   offset    IN             BIGINT,
   buffer    OUT            VARBINARY(8000));


DBMS_LOB.READ (
   lob_loc   IN             CLOB ,
   amount    IN OUT  NOCOPY INTEGER,
   offset    IN             BIGINT,
   buffer    OUT            VARCHAR2(8000) );

DBMS_LOB.READ (
   file_loc   IN             BFILE,
   amount    IN OUT   NOCOPY INTEGER,
   offset    IN              BIGINT,
   buffer    OUT             VARBINARY(8000));

结构

参数	说明
lob_loc	定位器
file_loc	文件路径
amount	字符个数
offset	偏移量
buffer	读操作的输出区