6 Replies Latest reply: Mar 26, 2013 12:35 PM by tgtrcg RSS

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

    893983
      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;