Categories
- All Categories
- 89 Oracle Analytics News
- 7 Oracle Analytics Videos
- 14.2K Oracle Analytics Forums
- 5.3K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 52 Oracle Analytics Trainings
- 59 Oracle Analytics Data Visualizations Gallery
- 2 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 4 Oracle Analytics Industry
- Find Partners
- For Partners
how to print BLOB images in the xml reports,Oracle apps
Summary
how to print BLOB images in the xml reports,Oracle apps
Content
Hi Friends,
I need to show the employee images from PER_IMAGES table . Please provide me any suitable solution if any one come across this kind of requirement .
Regards,
BH
Answers
-
How To Insert Images and Logo in the XML Publisher Reports and Documents? (Doc ID 550627.1)
How to Insert Images and BLOBs Dynamically into Word Template or Document? (Doc ID 443957.1)
HTH-
Jasmine
0 -
Hi there, we did something for our check logos printing.
Since logos are stored in the Databse as BLOB,
1 - we extract them using a function
SELECT util_Pkg. Convertblobtoclob64(Fl.File_Data)
FROM Fnd_Attached_Docs_Form_Vl Fv
WHERE ....
2 - util_Pkg. Convertblobtoclob64 is...
....
FOR i IN 1..CEIL(DBMS_LOB.GETLENGTH(p_blob_in) / l_buffer)
LOOP
l_varchar := utl_raw.cast_to_varchar2(utl_encode.base64_encode(DBMS_LOB.SUBSTR(p_blob_in,l_buffer,l_start)))
DBMS_LOB.WRITEAPPEND(l_clob_base64,LENGTH(l_varchar),l_varchar) ;
l_start := l_start + l_buffer;end loop;
...
3 - This extract a bunch of character and is within the xml file use to generate the check.
4 - in the rtf Template, we just call the XML elemend field and word handle it.
0