CREATE USER from within a trigger: get ORA-03001: unimplemented feature
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

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

Threaded View

  1. #1
    Join Date
    Sep 2006
    Location
    Oxford, UK
    Posts
    2

    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;
    Last edited by cgcenet; 09-28-2006 at 04:36 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width