2017  Kodetalk | Feedback | Privacy Policy | Terms | About
userimage

ORA-00922: missing or invalid option on changing the user password

This plsql is returning the error:
ORA-00922: missing or invalid optionDECLAREBEGIN
EXECUTE IMMEDIATE "ALTER USER upper(:USERNAME) IDENTIFIED BY :NEW_PASSWORD REPLACE :OLD_PASSWORD";
END;
userimage
EXECUTE IMMEDIATE 'ALTER USER ' || upper(:USERNAME) || ' IDENTIFIED BY ' || :NEW_PASSWORD || ' REPLACE ' || :OLD_PASSWORD;
Answer is