Host command

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||'_at_'||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 Received on Mon Apr 22 2002 - 19:45:49 CEST