CREATE USER from within a trigger: get ORA-03001: unimplemented feature

[cgcenet]

hello

I am trying to do a CREATE USER from a trigger, and get an ORA-03001 error.

I am using a very recently installed Oracle 10g on Linux (SUSE 9)

Alex

The error code

INSERT INTO password( User_Id, Password) VALUES ( 'u0001','desk' )
            *
ERROR at line 1:
ORA-03001: unimplemented feature
ORA-06512: at "HOSP.CREATE_USER", line 5
ORA-06512: at "HOSP.PASSWORD_AFTER_INSERT", line 2
ORA-04088: error during execution of trigger 'HOSP.PASSWORD_AFTER_INSERT'

The trigger is:

CREATE OR REPLACE TRIGGER password_after_insert
AFTER INSERT ON password
FOR EACH ROW
BEGIN
    create_user( full_db_user(:new.User_Id), :new.password  || '"');
END;

The create_user function, where the user is created, is

CREATE OR REPLACE PROCEDURE create_user
( user_id VARCHAR, password VARCHAR )
IS
PRAGMA AUTONOMOUS_TRANSACTION;
BEGIN
  EXECUTE IMMEDIATE 'CREATE USER ' || full_db_user(user_id) ||
 ' IDENTIFIED BY "' || password || '"';
END;