Skip to main content
F
faizank94658980
Known Participant
November 24, 2023
Answered

In Oracle19c BLOB records not showing into PDF

  • November 24, 2023
  • 1 reply
  • 412 views

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#">

 

    This topic has been closed for replies.
    Correct answer Charlie Arehart

    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? 

    1 reply

    Charlie Arehart
    Community Expert
    Charlie ArehartCommunity ExpertCorrect answer
    Community Expert
    November 24, 2023

    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 (troubleshooter, carehart. org)
      Charlie Arehart
      Community Expert
      Charlie ArehartCommunity Expert
      Community Expert
      November 24, 2023

      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.

      /Charlie (troubleshooter, carehart. org)
      Terms & ConditionsAccessibility statement
      Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices