Creating a Project using Pa_project_PUB.create_project error
set serveroutput on size 20000
-- Uses the cost plus template.
DECLARE
-- Variables needed to create task hierachy
level1 NUMBER;
level2 NUMBER;
level3 NUMBER;
a NUMBER;
m NUMBER;
--l_user_id NUMBER;
l_responsibility_id NUMBER;
parent_level1 VARCHAR2(30);
parent_level2 VARCHAR2(30);
parent_level3 VARCHAR2(30);
number_of_tasks1 NUMBER; -- number of tasks/levels