1 Reply Latest reply: May 29, 2013 2:07 PM by user9047639 RSS

    Using the APEX_UTIL.UNEXPIRE_END_USER_ACCOUNT procedure from SQL/Plus

    RichS
      Folks,

      I'm logging into the database with SQLPlus as BOB. BOB is the parsing schema for a workspace called BOBS_WORKSPACE. BOB has been granted the APEX_ADMINISTRATOR_ROLE.

      I'd like to use the BOB account to unexpire an end user account named LARRY.

      If I do the following, everything works right up to the time that I try to unexpire LARRY.

      sql > exec apex_util.find_security_group_id (p_workspace => 'BOBS_WORKSPACE');
      19283748917239487 <- Fake output

      PL/SQL procedure successfully completed.

      sql > exec APEX_UTIL.SET_SECURITY_GROUP_ID(19283748917239487 );

      PL/SQL procedure successfully completed.

      sql > exec apex_util.unexpire_end_user_account('LARRY');

      BEGIN apex_util.unexpire_end_user_account('LARRY'); END;

      *
      ERROR at line 1:
      ORA-06502: PL/SQL: numeric or value error: NULL index table key value
      ORA-06512: at "APEX_040200.WWV_FLOW_SECURITY", line 646
      ORA-06512: at "APEX_040200.WWV_FLOW_FND_USER_API", line 148
      ORA-06512: at "APEX_040200.WWV_FLOW_FND_USER_API", line 2694
      ORA-06512: at "APEX_040200.WWV_FLOW_FND_USER_API", line 2721
      ORA-06512: at "APEX_040200.HTMLDB_UTIL", line 1939
      ORA-06512: at line 1

      LARRY exists in SELECT user_name FROM wwv_flow_users;

      BTW, I'm trying to unexpire LARRY because I've moved LARRY from a test server to a production runtime only server and it appears that the 'reset your password' thing that you have to do when your account is expired is part of the APEX development environment and isn't supported in a runtime only environment...

      Any ideas?

      Thanks,

      Rich

      Edited by: RichS on Feb 5, 2013 12:30 PM extra exec in a statement