This procedure fails with this “Object Type” in the parameter block, **ku$_status1120.
**PROCEDURE p_status(p_job_name IN dba_datapump_jobs.job_name%TYPE
, – Job Name - from dba_datapump_job
p_job_owner IN dba_datapump_jobs.owner_name%TYPE
, – job_owner from dba_datapump_job
p_bool_wip IN OUT BOOLEAN
, – true when wip is true
p_bool_job_desc IN OUT BOOLEAN
, – true when Job Description is true
p_bool_job_status IN OUT BOOLEAN
, – true when Jobs status is true
p_bool_job_error IN OUT BOOLEAN
, – true when job_error is true
p_status IN OUT nocopy sys.ku$_status1120 – status
)
is
v_line_no integer;
begin
v_line_no = 100;
end;
/
SQL Navigator 6.6
Any suggestons?