• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

In Oracle19c BLOB records not showing into PDF

Community Beginner ,
Nov 23, 2023 Nov 23, 2023

Copy link to clipboard

Copied

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

 

Views

102

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines

correct answers 1 Correct answer

Community Expert , Nov 24, 2023 Nov 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? 

Votes

Translate

Translate
Community Expert ,
Nov 24, 2023 Nov 24, 2023

Copy link to clipboard

Copied

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)

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Nov 24, 2023 Nov 24, 2023

Copy link to clipboard

Copied

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)

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Beginner ,
Nov 24, 2023 Nov 24, 2023

Copy link to clipboard

Copied

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

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Nov 25, 2023 Nov 25, 2023

Copy link to clipboard

Copied

LATEST

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


/Charlie (troubleshooter, carehart.org)

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Resources
Documentation