OraFAQ Forum: Weblogic & Application Server » Passing Oracle logon infomrmations while Running Oracle 10g Report

Home » Fusion Middleware & Colab Suite » Weblogic & Application Server » Passing Oracle logon infomrmations while Running Oracle 10g Report

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Passing Oracle logon infomrmations while Running Oracle 10g Report [message #140289]

Mon, 03 October 2005 08:38

nuruthin
Messages: 3
Registered: March 2005
Location: Dubai

Junior Member

Hi friends,

I am using Oracle 10g Application Server & Oracle 10g Forms & Report services in two deffirent machines. J2EE Applications are running on Oracle 10g AS & Reports are running on Forms & Reports Services. I want to call Reports which is running on another server From Oracle 10g As. Everything is working fine. But I have to pass all the parameters thru a query String. So the problem is all the endusers can view the Database details by taking the properties.

#) I want to set the Database Logon information some where in any confiruration file and this should read when calling reports. so that i can avoid passing of Database user informations. Is there any way to configure like this?

#) Multiple applications are running on Oracle AS and each applications are using defferent schema. How can I set the different User Informations in the configuration file.

I want to completely avoid passing of Oracle user informations thru http.

thanks & regards

Nuruthin Ahammed
nuruthin@hotmail.com

Report message to a moderator

Re: Passing Oracle logon infomrmations while Running Oracle 10g Report [message #140297 is a reply to message #140289]

Mon, 03 October 2005 09:19

kmmfoo
Messages: 38
Registered: June 2005
Location: massachusetts

Member

This is an answer to only part of your question.

I've never seen it described in oracle's documentation, but you can pass parameters to an oracle reports server as html form values instead of using querystring values.

That stops the information from appearing in the browser's "location" bar.

My own approach has been to encode an html form with the parameters

  target="_blank" 
  method="post"
  action="[full url of the report here]"

As far as the rest of your questions, I suspect there's probably a way to do them but I don't know it myself. Perhaps someone else will be able to answer that part.

Report message to a moderator

Re: Passing Oracle logon infomrmations while Running Oracle 10g Report [message #140430 is a reply to message #140289]

Tue, 04 October 2005 03:50

nuruthin
Messages: 3
Registered: March 2005
Location: Dubai

Junior Member

Thanks for ur reply.

But I am showing reports in a separate popup window since the client wants like that. Also we have set the the look and feel without any frames. But your method can be follow if I do not get any other solution.

Once again thanks

Nuruthin Ahammed

Report message to a moderator

Re: Passing Oracle logon infomrmations while Running Oracle 10g Report [message #140481 is a reply to message #140430]

Tue, 04 October 2005 08:02

kmmfoo
Messages: 38
Registered: June 2005
Location: massachusetts

Member

umm...

this approach _does_ load the reports in a separate popup window. that's what the "target" parameter of the form tag does.

Report message to a moderator

Previous Topic:	Is Oracle 9ias Release 2compatible with Forms 6i??
Next Topic:	Configuration web server mod plsql

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Feb 12 02:54:25 CST 2025