Change Oracle Password [message #38485] |
Mon, 22 April 2002 09:25 |
Chris
Messages: 128 Registered: November 1998
|
Senior Member |
|
|
Hi,
This is a piece of code that I use for updating the Oracle password using Oracle Forms.
"......
ID := :PASSWD.User_Name;
NewPW := :PASSWD.New_PW;
Command := 'plus80w '||id||'/'||CurPW||'@'||dest||' @changepw '||id ||' '||newpw ;
HOST(Command,NO_SCREEN);
IF FORM_SUCCESS THEN
Message('Request Processed.');
ELSE
Message(TO_CHAR(Message_Code) || ':' || MsgTxt;
RAISE Form_Trigger_Failure;
END IF;
..."
It works fine except for some cases like the password has been used previously, there is no way for me to identify the problem or recieve the error message. FORM_SUCCESS is still set to TRUE because nothing wrong with Command.
Can someone help me with this?
Thanks in advance.
Chris
|
|
|
|