|
Hi ,
i have a procedure to open the BFILE
data.
CREATE OR REPLACE procedure openmyfile aslob_loc bfile ;filesize number;lob_loc bfile:=bfilename('IMG','a.jpg'); begin--select f_lob into lob_loc from lob_table where key_value=21;dbms_lob .fileopen(lob_loc,dbms_lob.file_readonly); dbms_lob.fileclose(lob_loc);filesize :=dbms_lob.getlength(lob_loc);dbms_output .put_line(filesize); end;procedure compiles w/o errors and when i execute the procedure it does w/o any errors but it doesn't open the file. i have the procedure on the sun server and also the jpg file.i am trying to execute the procedure from oracle client but it doens't open the file but just just o/ps the filesize.what is that i need to do to make the file open on the client m/c.i understand that the file "a.jpg" should open.Am I missing anything? ravi |
