Re: PL/SQL: Reading Blobs
From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sat, 21 Jul 2001 21:50:25 GMT
Message-ID: <9g2st8$6ndpu$1_at_ID-62141.news.dfncis.de>
Date: Sat, 21 Jul 2001 21:50:25 GMT
Message-ID: <9g2st8$6ndpu$1_at_ID-62141.news.dfncis.de>
"Gerry Jacobs" <gee_jay__at_yahoo.com> wrote in message
news:ce2b54c8.0106110725.7809ed27_at_posting.google.com...
> 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
Do you think the group can *guess* the error?
Regards,
Sybrand Bakker, Oracle DBA Received on Sat Jul 21 2001 - 23:50:25 CEST