I have a pl/sql procedure that streams a letter pdf (on file sever) to a web page (see below). For some reason, a letter every now and then will have a missing line of text. None of the text is there on one line, but the last character which might be a '.' or a '-'.
For instance- the line that starts 'This decision', only has the '.'. I can't figure out what is causing this. Any ideas?
The Committee has carefully reviewed xxx. Unfortunately, we cannot offer you xxxxxxx at this time due to the competitive nature of the applicant pool.
This decision is especially difficult given your family’s affiliation with xxxx.
procedure p_showPDFDoc (opq in szrxadm.szrxadm_id%type, zyn in varchar2, tsr in rowid) is
lFile BFILE := null;
letter varchar2(60) := null;
dob varchar2(35) := null;
dob := to_date(zyn, 'J');
letter := f_get_filename(opq, dob, tsr);