Home » Developer & Programmer » Forms » Read URL Header in forms (11g)
icon12.gif  Read URL Header in forms [message #569476] Fri, 26 October 2012 23:08 Go to next message
harpreetsinghkup
Messages: 52
Registered: May 2006
Location: Mumbai
Member

Hi,

We are using 11g forms and want to read url's header's variables via forms.

Could you please help us out?

Rgds,
Harpreet Singh
Re: Read URL Header in forms [message #569482 is a reply to message #569476] Sat, 27 October 2012 02:10 Go to previous messageGo to next message
Littlefoot
Messages: 19678
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Maybe it's just me, but - I don't understand what "url's header's variables" are. Could you post an example?
Re: Read URL Header in forms [message #569517 is a reply to message #569482] Mon, 29 October 2012 01:23 Go to previous messageGo to next message
harpreetsinghkup
Messages: 52
Registered: May 2006
Location: Mumbai
Member

Hi,

We are migrating oracle forms 6i to form 11g. We want to incorporate SSO functionality for 11g application but as per company policy we can't use oracle provided SSO functionality.
Now coming to point.
Because, my application is written in this manner, each user is logging to forms as solitary oracle user and we are managing user's menu level right via oracle roles.
We have SSO URL (http://example.com), after users authentication it is providing users id in URL's header. Now we have to grab these user ids and login to oracle forms. As of now, we are not aware how to read this header via forms?

Hoping we have provided sufficient information. Please advice.


Regards,
Harpreet Singh
Re: Read URL Header in forms [message #569524 is a reply to message #569517] Mon, 29 October 2012 03:17 Go to previous messageGo to next message
Littlefoot
Messages: 19678
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I'm sorry, I wouldn't know how to do that. Hopefully, someone else will be able to assist.
Re: Read URL Header in forms [message #569934 is a reply to message #569524] Sat, 03 November 2012 05:48 Go to previous messageGo to next message
harpreetsinghkup
Messages: 52
Registered: May 2006
Location: Mumbai
Member

Hi,


I have found the way to handle this.

1. Use sys.UTL_HTTP package and you can read header of URL. The basic requirement for UTL_HTTP package is xml db instalation. Ask to your dba if that is not present.
2. You can use a middle layer(JSP/JAVA etc) which can read url header and within jdbc connection that can be fetch into oracle database.
example : I have my company's SSO site, After athorizaton it is redirecting to my new layer (JSP) page. JSP page can be deplyed via weblogic admin console as a war file. Now

1. JSP is reading all the parameters i.e. username/session_id. and i am performing my oprations accordingly.

2. In there is one perdefined string called &otherparams which helps us lot here. We can get any parameter via jsp and redirect it into forms url like below.


http://hostname:8888/forms/frmservlet?config=abc&otherparams=SESSION_ID=123

Enjoy

Harpreet Singh

[Updated on: Sat, 03 November 2012 05:54]

Report message to a moderator

Re: Read URL Header in forms [message #569935 is a reply to message #569934] Sat, 03 November 2012 05:53 Go to previous message
Littlefoot
Messages: 19678
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Cool! Thank you for sharing it with us.
Previous Topic: Oracle 10g key combination to call form trigger
Next Topic: FRM-40735: WHEN-BUTTON-PRESSED trigger raised unhandled exception ORA-06502
Goto Forum:
  


Current Time: Mon Oct 20 13:10:53 CDT 2014

Total time taken to generate the page: 0.10264 seconds