Remove the relation between projects.
Input
Parameter | Type | Description |
|---|---|---|
v_parent_project_id | NUMBER | The primary key value of the project. |
v_child_project_id | NUMBER | The primary key value of the child project. |
Example
declare v_parent_project_id CONSTANT PROJECT.PJ_ID%TYPE:= 3; v_child_project_id CONSTANT PROJECT.PJ_ID%TYPE:= 4; begin P_PROJECT_MANAGER.REMOVECHILDPROJECT( v_parent_project_id, v_child_project_ID); end; / |
Exceptions
• Input parent project ID does not exist.
• Input child project ID does not exist.
• Input parent project is a child of input child project.
• Input child project is not a child of input parent project.
• Error in REMOVECHILDPROJECT: (SQL code).