Home » Developer & Programmer » Forms » How to change user password thru forms4.5
How to change user password thru forms4.5 [message #78557] Sun, 03 March 2002 03:17 Go to next message
sethu
Messages: 9
Registered: May 1999
Junior Member
I want to create a form to allow users to change password. I tried FORMS_DDL as follows
DECLARE
UNAME VARCHAR2(50);
BEGIN
SELECT USER INTO UNAME FROM DUAL;
FORMS_DDL('ALTER USER'||'UNAME'||'IDENTIFIED BY'||':NEWPWD');
MESSAGE('PASSWORD SUCCESSFULLY CHAGED');
END;
/*NEWPWD is the new Password typing field*/
But no use. The passowrd remails old one only.
Any body can help?
Re: How to change user password thru forms4.5 [message #78568 is a reply to message #78557] Mon, 04 March 2002 01:01 Go to previous message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
what do u mean by "But no use. The passowrd remails old one only.". can u explain what is the problem exactly.
Previous Topic: Dynamic Table Problem (not yet solved ) (please Urgent)
Next Topic: Re: How to change user password thru forms4.5
Goto Forum:
  


Current Time: Thu Mar 28 13:59:01 CDT 2024