[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 6721
  • Last Modified:

Oracle forms web.show_document() stopped working

I am using Oracle forms, and sometime in the last 7 months web.show_document() stopped working.  All I am wanting to do is view a pdf that is stored in the db.  Right now I download the pdf to a temp file and (if it worked) view it with web.show_document() .  Does anyone know of some event that affected the functionality of web.show_document() and how to remedy it, or perhaps an easier way to launch a pdf from oracle forms.  


0
cliphcasey
Asked:
cliphcasey
  • 3
  • 2
1 Solution
 
Helena Markováprogrammer-analystCommented:
I use Forms10g and there are no problems with web.show_document.
We use RP2RRO.PLL library (provided by Oracle) for reports (also PDF) - there is web.show_document() used there.

I think that you display pdf right way but there can be another problems with creating a temp files,paths etc.
0
 
bpeterseCommented:
web.show_document is one of the 2 ways to render web based reports in 10g, so you're using the correct code.  We usually specify the desformat=pdf in the url when running reports.  Is the PDF actually stored in the DB or are you creating it on the fly?

That said, Henka hit on something that's sounds altogether too familiar with Oracle.  If nothing in your code has changed, I would definitely check your environment for the UID that starts the Forms servlet - sounds like it might be something as basic as an env setting.  

Do you get any ORA errors when you try to run the form/report?  Do you have logging enabled that you can check?
0
 
cliphcaseyAuthor Commented:
Thanks for responding,

The pdf is stored in the database as a lob, I download to the C: and then from there I attempt to view it with
web.show_document.  I also found out that all of our clients that use this functionality have lost it, and all at about the same time.  Furthermore, I receive no ORA errors.  I checked the environment settings and everything seems good.  Any more suggestions would be greatly appreciated.
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
bpeterseCommented:
So the form you're using is downloading the file to your local drive and the same form is supposed to open it as well?  Where does it fail?  Does the file get to your local drive?  
0
 
cliphcaseyAuthor Commented:
Yes, it makes it to the local C: drive (I am sending it there because on my test system the Client_win_api_environment.Get_Temp_Directory(true) is not working).  At this point I want to open the file and I call web.show_document('file:///' || vsFileName, '_blank');, this is where it fails.

Thanks again
0
 
bpeterseCommented:
I showed that to our forms guru and he said it looks correct.  Also - he'd heard of the same thing happening to someone else and their solution was to reinstall Adobe and refresh the browser screen (i.e. clear the cache).  
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now