Oracle Reports 10g with Coldfusion Login?

[ironyx]

I have a coldfusion form that I am trying to pass a login username and
password. The problem is I know Oracle 10g web reports can take login
parameters in a URL, but I can't seem to figure out how to encode/hide it and
have Oracle read it. I want to be able to hide the username and password
(obviously for security) and I also want to be able to pass special
characters... does anyone have suggestions? I might end up switching to an
Oracle form for login, but being a coldfusion junkie... I have given myself
quite a headache!

[drew222]

If you want Oracle to read the login/password from a URL, then you are going to
have to pass it. In CFMX 7, Macromedia also removed the ability to ENCRYPT the
url arguments. I'm not sure why but they did. You best bet is to store the user
information as a client variable (which is stored in the database) and have
Oracle read the information from the CFDATA table. This is a somewhat hookie
way to do it but I can't see any other way.

Sorry,

[ironyx]

I am not much of an oracle forms/reports developer... so do you know where I
might find guidance on how exactly this would be done dynamically? I will be
googling in the mean time. Is this something like writing to the cgicmd.dat
file. This seemd like a great idea, but I could only find how to do this
statically. Sorry but if in my mind I know how it works... it makes it easier
for me to search and destroy the issue. The other thing is the logins are
already stored in Oracle... why would I write to a table...and how do I get it
back to the Oracle report server to show it authenticated...

Thanks for replying, sorry I have so many questions!

Thanks,
Va