Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to display BLOB file of type pdf or doc or jpg or gif in report

Status
Not open for further replies.

Iloveoracle

Programmer
Oct 2, 2006
22
US
Hi ,
In one database table we have one column named file_content is having BLOB and other column is having file_name .This file_name is pdf or doc or gif or jpg.

I have to display these files in the report by using paramete ID.For example If I give id='SMMXX' then it has to display the related file_content and file_name from
the database table,that file is either in pdf or doc or jpg or gif format and file_content is BLOB type.I have created one field with source=file_content and I have set the
file format property for this field is image.Then it will display the file, if
it is gif or jpg type.But if it is pdf or doc type it will give error.If change
the file format image to text it won't work for jpg or gif formats.Could u
please tell the solution to display the file according to their formats


Thanks
gp
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top