Change user password with stored procedure ?

Is it possible to that the user changes his password with a stored procedure ?

I tried the following in a procedure (with sUsername, sNewPassword as parameters for the procedure)

ALTER USER sUserName IDENTIFIED BY sNewPassword;

but always got a compile error. Is there another way that a user can change his password.

I use VB-Client and Oracle8.

Thanks for your help,

// Juergen Received on Thu Nov 19 1998 - 05:59:35 CST