| password decryption problem with oracle forms 9i [message #466941] |
Wed, 21 July 2010 13:15  |
rajesh4851
Messages: 89
Registered: January 2007
|
Member |
|
|
Hi Friends,
I am facing password decryption problem with my oracle forms 9i version. (forms 9i , d/b-oracle10g, application server 10g)
My current db is in oracle9i (windows server), it is migrated to oracle 10g in unix server. (dont have more details about server).
In my application "loginscreen.fmb" is fetching the p/w from security_table (here p/w stores in encrypted format) and decrypt at form level. If both are matching, then only it allows the user to proceed further.
But when it is decrypting p/w from the forms(internally calling the decryption function from d/b), junk data is displaying (i put debug mesage and found this ).
My question is, when forms connected to the d/b if that is in unix server, decryption functionality will not work?
I did same decryption using the same key from sql*plus, it is giving correct values. What is the diff between decryption from forms and sql*plus ( both case it is calling the same function that is stored in the d/b).
[MERGED by LF]
[Updated on: Tue, 03 August 2010 13:55] by Moderator Report message to a moderator |
|
|
|
|
|
| USER_NLS_CHARACTER_SET [message #469138 is a reply to message #466941] |
Tue, 03 August 2010 08:55  |
rajesh4851
Messages: 89
Registered: January 2007
|
Member |
|
|
Hi,
I have one problem with USER_NLS_CHARACTER_SET in oracle forms9i.
In forms USER_NLS_CHARACTER_SET is showing as WE8MSWIN1252
In the database (oracle 10g) NLS_CHARACTERSET is WE8ISO8859P1.
I want to change the forms to point the CHARACTERSET to WE8ISO8859P1. How can i do this? I should not change the database NLS_CHARACTERSET, because it will effect to other applications.
Why there is difference in characterset for forms and database? How to set the characterset to Oracle Forms? Is it in environment settings? or from OS? or any application server settings?
My application is not able to decrypt the password , i beleive this is the reason.
Pls help me.
Regards,
Rajesh.
|
|
|
|
| Re: password decryption problem with oracle forms 9i [message #469143 is a reply to message #467052] |
Tue, 03 August 2010 09:09 |
rajesh4851
Messages: 89
Registered: January 2007
|
Member |
|
|
Thanks David.
I am doing the encryption using database function.
There is no upper or conceal option.
I found a major difference in characterset from database to oracle forms.
My database (oracle 10g) has NLS_CHARACTERSET - WE8ISO8859P1. and the forms 9i is using - WE8MSWIN1252.
Is this the reason? if i change the forms characterset to
WE8ISO8859P1 will it work?
Pls let me know?
Regards,
Rajesh
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
