Determining server name in Oracle Forms 10g

35 pts.
Tags:
Oracle Developer 10g
Oracle Forms
Oracle Forms 10g
Oracle Reports
Report Server
I'm converting a Developer 6i Forms/Reports application to 10g. I'm using WEB.SHOW_DOCUMENT to display the report. Part of the URL that I'm passing as a parameter to the WEB.SHOW_DOCUMENT is the server name. As the form is tested and passes from development into Beta and then to Production, the servers change and of course the call to the report fails. Is there a way to determine the server within the form application so that I can build the URL parameter dynamically?

Software/Hardware used:
Oracle Forms Developer 10g
ASKED: March 26, 2010  2:17 PM
UPDATED: March 29, 2010  8:05 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

I don’t know of a way to ‘determine’ the reports server name, but you could store it in a database table, and read it from there before calling the report. Your production database should have the production server name, and your development/test databases should have their corresponding server names.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following