Click to See Complete Forum and Search --> : Get http header (env. variable), then send result to PL/SQL procedure.


linda1115
01-01-2004, 08:19 PM
Hello,

I need to get an environment variable from an HTTP header, and then send that variable as a parameter in a PL/SQL procedure.

Currently, I'm using a logon screen (html), with FORM attributes to send the userid and password to the PL/SQL.

However, now I want to use the company's corporate web security routine for validation. When a user logs on to my web site, corporate web security will intercept the logon id and validate it. If it is valid, I want to pass that logon id to a PL/SQL procedure.

Oracle has a utility, UTL_HTTP, which is supposed to let me access the header info. I'm not sure how to handle this on my current html index page, because I won't need the input fields on that page anymore.

I have some JavaScript on the index page. Can the JavaScript be modified to accomplish what I need?

Any help would be appreciated!

Thanks.

Khalid Ali
01-01-2004, 08:22 PM
I doubt that..javascript has very limited access to HTTP header infor.
You will end up using some kind of server side scripting language