In Oracle19c BLOB records not showing into PDF

[faizank94658980]

Previously I was using Oracle11g now migrated at Oracle19c. The BLOB records dislaying fine in PDF with Oracle11g but show this with Oracle19c.

Error

Failed to load PDF document.

I am using currently CF21. I have used tag to dispaly binary file(BLOB data).

<cfparam name="rc.data" default="">

<cfheader name="content-disposition" value="inline; filename="eid.pdf">
<cfcontent type="application/pdf" variable="#rc.data.ATTACH_EMID#">

[Charlie Arehart · Accepted solution]

Faizan, before exploring the error, let's consider a couple of things first :

1. Look in the cf admin at the datasource page for that Oracle datasource: it has a "blob" checkbox in its advanced settings. Is that enabled in cf2023, assuming it was in cf2021?
2. If that change doesn't help, try doing a cfdump of the cfquery (or cfstoredproc) call's results. Do you see anything unexpected or diagnostically useful? If not, what if you compare it to the same cfdump done in cf2021? 

[Charlie Arehart]

Faizan, I see you marked my answer as correct (as I got an email notifying me). So was it just the need to check that blob box? If so, great. Or did you the dump to show something unexpected. 

Do let us know, though. A problem here is that readers can't see who marked an answer correct, and since authorized folks can also mark replies as "the answer", those seeing this thread wouldn't know if your problem was solved, unless you say so.

[faizank94658980]

The 1st option worked. Thanks to show right way always.

[Charlie Arehart]

Great to hear hear. Thanks for the update and for the kind regards.