Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

GetJobId and File Names

482629Jan 13 2006 — edited Jan 16 2006
I have the following requirement:
Produce my report output in an editable format (rtf) that can be automatically opened by the end-user.

Progress:
* Report output generates using run_report object from a 9i form
* Using showjobs I can see my output in the report server queue, the 'output name' is set correctly with a usable file extension 'rtf' Eg: MyFileName.rtf
* I can access the output using getjobid and web.show_document (this is how I normally access other report output filetypes, generally pdf) - however the following issue arises....

Problem:
When I do my show_document and pass in the correct getjobid URL, the file looses its naming context and defaults to a standard IE save/open/cancel dialog using a filename of 'getjobid<x>' with no extension.

For example: 'You are downloading the file getjobid13201from.... would you like to save the file or open it'

I can download the file, but it has no associated program (the filename has no extension) so I have to select my editor before I can view the output.

I understand that my browser has no means of determining the filename at this point, so I want to direct the calling URL to use the 'output name' as stored in the report server queue (or some other filename with the correct extension)

Perhaps there is some way of directing the output stream to be named? Maybe I am missing something in terms of the mechanism?

The getjobid built in provided by the reports server may need configuring to allow the 'output name' in the report server queue to be used as a file name?

Any help would be appreciated here :>

Message was edited by:
GarethAdamson
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 13 2006
Added on Jan 13 2006
5 comments
1,569 views