Hello,
I've got a strange situation occurring within Apex. I am playing with the Sales Forecaster packaged app, and have tweaked the Opportunity Notes field to display as HTML instead of raw text.
When I enter the Note text, the input field is now set to a HTML editor. This successfully allows me to create the standard array of formatting as per this input mode, and the formatted code is displayed successfully. To be precise - within the Note Creation or Edit page (this is page 22 of the packaged app), ALL of the HTML formatting is displayed correctly.
The problem arises when I view the note, as it is displayed on the Opportunity Detail page (page 16 of the app). When the notes are viewed from this page, the font SIZE is not displayed correctly. All of the other HTML formatting is displayed perfectly (eg: bullets, colours, etc), except for the font size, which is all the same. I've pasted in the PL/SQL code below that is generating the output. NB: I've tweaked the PL/SQL to bypass the Sales Forecast function that strips out the HTML tags, so this isn't the problem. I thought perhaps the SIZE tags in the HTML may be dependent on a CSS or something similar which is applied differently when accessed via PL/SQL as opposed to the HTML editor.
If anyone has any suggestions I'd be grateful. I've searched the forums & studied the doco but can't find any answers.
Kind Regards,
Andrew.
declare
j int := 0;
c varchar2(32767);
offset int := 1;
i int;
begin
for c1 in (
select "ID",
NOTE,
"CREATED_BY",
"UPDATED_ON", created_on
from "EBA_SALES_DEAL_NOTES"
where deal_id = :P16_ID
order by created_on desc) loop
offset := 1;
j := j + 1;
i := 0;
loop
i := i + 1;
if i = 1 then
htp.prn('<table width="100%" bgcolor="dddddd"><tr><td>'||
'
<img src="#IMAGE_PREFIX#e2.gif" width="18" height="18" alt="Edit" title="Edit" /></td>'||
'<td>'||j||'.</td><td>Posted by: <b>'||c1.created_by||
'</b> '||to_char(c1.created_on,'Day Month DD, YYYY HH:MIPM')||'</td><td align="right">
</td></tr></table>');
end if;
c := dbms_lob.substr(c1.note,10000,offset);
htp.prn(c);
exit when offset + 10000 >= nvl(dbms_lob.getlength(c1.note),0);
offset := offset + 10000;
end loop;
htp.prn('<p />');
end loop;
end;