This discussion is archived
6 Replies Latest reply: Mar 26, 2013 10:35 AM by tgtrcg RSS

Changing password via EPG in Oracle 11g (XE or EE) - error 04020

893983 Newbie
Currently Being Moderated
Hello,
I prepared a form for changing password for end user via Http. The form calls a procedure for changing password (listed below). This procedure works perfect under Oracle 9.2.0 (with Apache) but under 11g (with EPG) gives an error 04020 - deadlock detected while trying to lock object 55.
Any ideas where the porblem is? Could I get any help?

procedure:
begin

execute immediate 'alter user '|| upper(USER)
|| ' identified by ' || '"' || in_PWD_new_A || '"'
|| ' replace ' || '"' || in_PWD_old || '"';

htp.p(' <script>
'|| ' alert('Password succesfully changed'');
'|| ' </script>');

exception
when others then
htp.p(' <script>
'|| ' alert('''||SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1, 255)||''');
'|| ' </script>');
end;

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points