Re: Problems with DBMS_LOB package!!!

A copy of this was sent to "Michael King" <mkrol_at_tukan.internet-info.com.pl> (if that email address didn't require changing) On Mon, 05 Jul 1999 14:14:52 GMT, you wrote:

>Hi!
>I notice something strange in Oracle8 system.
>Before execute PL/SQL code, I created directory "www" on path c:\temp, where
>existed binary file ziemia.bmp( size of file large than 38kB).
>This is PL/SQL code:
>
>declare
> w binary_integer;
> b bfile;
> r long raw;
>begin
> b:=bfilename('www','ziemia.mp');
> w:=dbms_lob.getlength(b);
> dbms_lob.fileopen(b);
> dbms_lob.read(b,w,1,r); -- error in 2 parametr
> commit;
> dbms_lob.closefile(b);
>end;
>
>When I wanted read the file from file system ( I used DBMS_LOB.READ
>function), the system returned the error. According the system parametr w
>is: invalid or out of range. In my opinion this is stupid. Maybe I am wrong.
>

PLSQL variables are limited to 32k in size. You must read 32k or less at a time and process the data that way.

>Any sugg.. !!!
>
>Michal
>

--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Mon Jul 05 1999 - 13:01:55 CDT