(wrong string) ¿How to get server bfiles into forms?

From: Sex_appeal <aa_at_aa.es>
Date: Tue, 16 Nov 1999 18:38:58 +0100
Message-ID: <80s4ss$m3j$1_at_lola.ctv.es>

I have a table with a bfile column, filled with directory and filename data. I wish to get
the image associated to each file and show it in my form. I can't program a function in Oracle Forms because it doen't have the bfile datatype, so
I made a stored procedure:

function read_image
return long raw
is
  file_loc bfile;
  length integer;
  lr long raw;
begin
  file_loc:=bfilename('CONTEXT_DIR','arrow.gif');   length:=dbms_lob.getlength(file_loc);

  dbms_lob.fileopen(file_loc);
  dbms_lob.read(file_loc,length,1,lr);
  dbms_lob.fileclose(file_loc);

  return lr;
exception
  when others
  then
    dbms_output.put_line('exception:'||sqlcode); end;

This stored procedure CAN read the image information, and I can leave it into an Oracle Forms long raw datatype variable, but I CAN'T SHOW IT!, because when I assign this variable to an image item ":block2.item3:=l;" Oracle iusses the error: "transfer variable 'block2.item3' is incorrect" Can you help me?? Received on Tue Nov 16 1999 - 18:38:58 CET