Hi,
I have an application in FORMS 12C. I logon using a user with an expired password. My application asks me to enter a NEW password, which I do. When user clicks ‘OK’ I then use FORMS_DDL to set the new password as follows...
I have used the following command to change expired password using my customized change password form:
FORMS_DDL('ALTER USER ' || USERNAME || ' IDENTIFIED BY ' || NEW_PASSWORD);
after that i tried to re-login using new password as follows:
LOGOUT;
LOGON (USERNAME, NEW_PASSWORD || '#' || CONNECT_STRING, FALSE);
i am facing the following Issues:
1. Password does not changed at all in the database level.
2. FORMS_DDL does not through any exception.
3. As a result, when i execute LOGON... it throws ORA-01017: invalid username/password, logon denied.
Am I missing something?
Please help.
Thanks in advance.
Marc Lafontaine