CREATE USER from within a trigger: get ORA-03001: unimplemented feature
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
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:
Code:
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
Code:
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;
