Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to view a blob pdf file

446155Aug 11 2005 — edited Aug 12 2005
Hi,

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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 9 2005
Added on Aug 11 2005
3 comments
652 views