Hi all,
I wrote an SP to change the supplied user's password but iam getting error as ora-00922 missing or invalid option alter user and find the code I used.
create or replace PROCEDURE accout_change_3 (
P2_USERAME VARCHAR2,
P2_PASSWORD VARCHAR2
) IS
sql_string VARCHAR2(500);
usr VARCHAR2(50);
pwd VARCHAR2(50);
BEGIN
sql_string := 'alter user dbms_assert.SCHEMA_NAME(:username)
identified by dbms_assert.ENQUOTE_NAME(:password);';
EXECUTE IMMEDIATE sql_string using P2_USERAME,P2_PASSWORD;
END;