Allowing a user to create Oracle user and reset their password through a stored procedure

Hi,

I an using Oracle DB 10.2.0.2.0

I would like to delegate user creation and password reset to a specific oracle user without giving him CREATE USER privilege

I've created this PL/SQL procedure :

CREATE OR REPLACE PROCEDURE SYSTEM.delegated_create_user (

   myusername in VARCHAR2)

AS

   v_count       INTEGER        := 0;

   v_statement   VARCHAR2 (200);

BEGIN

   SELECT COUNT (1)

     INTO v_count

     FROM all_users

    WHERE username = UPPER (myusername)

      AND username NOT IN

          ('SYS',

           'SYSTEM',

           'OUTLN',

           'DIP',

           'ORDPLUGINS',

           'TSMSYS',

           'DBSNMP',

           'WMSYS',

           'EXFSYS',

           'XDB',

           'ANONYMOUS',

           'ORDSYS',

           'SYSMAN',

           'SI_INFORMTN_SCHEMA',

           'MDSYS',

           'XXX123');

   DBMS_OUTPUT.put_line ('After select into');

   DBMS_OUTPUT.put_line ('v_count=' || v_count);