OraFAQ Forum: Forms » How to change user password thru forms4.5

Home » Developer & Programmer » Forms » How to change user password thru forms4.5

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to change user password thru forms4.5 [message #78557]

Sun, 03 March 2002 03:17

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?

Report message to a moderator

Re: How to change user password thru forms4.5 [message #78568 is a reply to message #78557]

Mon, 04 March 2002 01:01

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.

Report message to a moderator

Previous Topic:	Dynamic Table Problem (not yet solved ) (please Urgent)
Next Topic:	Re: How to change user password thru forms4.5

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Sep 09 10:10:07 CDT 2025