Please help - stored procedure

Hi Experts,

I am new to Oracle & trying to create a following stored procedure.

create procedure change_password (userid in varchar2, passwd in varchar2) as begin
alter user userid identified by passwd;
end;

The idea is to create a stored proc and allow users to change their password from a
front-end application. I get the following message when I try to save the procedure.

PLS-00103: Encountered the symbol "ALTER" when expecting one of the following:
begin declare exit for goto if loop mod null pragma raise return select update while <an identifier> <a double-quoted delimited-identifier> <a bind variable> << close current delete fetch lock insert open rollback savepoint set sql commit <a single-quoted SQL string>

Can anyone tell me what is wrong with this code? If there is a better way to do it, please show me

Thanks

CGS
tcgs_at_hotmail.com Received on Tue Apr 25 2000 - 00:00:00 CDT