Before you can delete an existing user, you must provide a representative user. Important data that is linked to the user you are deleting can be reassigned to the representative user.
The arguments of the DELETE_USER function are listed below.
Argument Name |
Type |
In/Out |
---|---|---|
P_USER |
VARCHAR2(10), m_users.m_usr_id |
IN |
P_REP_USER |
VARCHAR2(10), m_users.m_usr_id |
IN |
P_PROJ_ID |
VARCHAR2(10), m_projects.proj_id |
IN |
P_COMMIT |
VARCHAR2 |
IN |
P_RESULT |
NUMBER |
OUT |
P_MESSAGE |
VARCHAR2 |
OUT |
The function returns m_users.m_usr_id.