Hey everybody , I'm working on Oracle developper , I need help , well I need to create a table WORK_ODI_DBA_DEPENDENCIES that import data from dba_dependencies , I dont know why my procedure doesn't work , it show me : Source does not have a runnable target /// plz does anyone know why ?

here is my code :
----------------------------------------
CREATE OR REPLACE PROCEDURE PRC_ALIMENTERDEP IS
BEGIN

delete from WORK_ODI_DBA_DEPENDENCIES;
insert into WORK_ODI_DBA_DEPENDENCIES (referenced_owner, referenced_name, type, name)
select
referenced_owner, referenced_name, type, name
from
SELECT referenced_owner, referenced_name, type, name from dba_dependencies WHERE
referenced_owner IN ('ODS', 'DWH') and referenced_type = 'TABLE';

COMMIT;

EXCEPTION
WHEN OTHERS THEN
ROLLBACK;

END PRC_ALIMENTERDEP;
----------------------------------
I need to create this table to use it as source table in ODI
Thank u in advance ^^

السلام عليكم ورحمة الله وبركاته

 

ملف مرفق

Source does not have a runnable target.doc