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.
For quick reply Cheers