how to view a blob pdf file
446155Aug 11 2005 — edited Aug 12 2005Hi,
i have inserted some pdf files as out-of-row BLOB in my table
but now i want to view the pdf files. how can i do this.
can i view the pdf files wither in TOAD or sqlplus.
this is what i did:
"declare
fileout raw(32767);
begin
select file
into fileout
from table
where id=1;
dbms_output.put_line(fileout);
end;"
but when i execute this above procedure in SQLPLUS after giving
SET LON 64000
i get error saying: "Numeric error"
Can someone help me please.
Thanks,
Philip.