PL/SQL: Reading Blobs

Hello,

how can I load a part from a blob field using PL/SQL? I tried the code below, but I can't compile it. The blob fields contain ascii and binary files.

create or replace function load_filedata(pid number, pstart number, psize number)  RETURN raw
 IS retval raw;
 BEGIN
   select dbms_lob.substr(filedata, psize, pstart) into retval from table where id=pid;    RETURN retval;
 END; Thanks in advance,

Gerry Jacobs Received on Mon Jun 11 2001 - 17:25:22 CEST