This content has been marked as final. Show 2 replies
zycoz100 wrote:To get a Display Item to render as HTML, in the item definition Security section set Escape special characters to No.
I have a display only field and i am trying to retrive it a value using function ...The idea of using blob is from the following example ..
I created the following function.. in A display only function.
return '<img src="' || APEX_UTIL.GET_BLOB_FILE_SRC('P375_PICTURE',1204,null,'inline') || '" />';
but the output is junk character
The output is the one below
<img src="apex_util.get_blob_file?a=231&s=16387884076007&p=375&d=26249204291254605&i=26247831247254566&p_pk1=1204&p_pk2=&p_ck=C226897F204BFA329F601AF2ED72ECDA&p_content_disposition=inline" />
For a report column, ensure the Display Text As report column attribute is Standard Report Column rather than the default Display as Text (escape special characters).
However in APEX 4.x, using a Display Image item and declarative BLOB support is preferable to such manual methods. Images can be formatted using the item HTML Form Element Attributes property, or via CSS.