Unable to compile or drop a Package
Hi,
I'm facing a problem while trying to compile or drop a invalid Package. The sqlplus hangs up without throwing any error.
From TOAD, I find that at the time of "Droping" the package, the statement that hangs up is below:
----------
BEGIN
/* NOP UNLESS A TABLE OBJECT */
IF dictionary_obj_type = 'TABLE' AND SYS.dbms_cdc_publish.active > 0
THEN
SYS.dbms_cdc_publish.change_table_trigger (dictionary_obj_owner,
dictionary_obj_name,
sysevent
);
END IF;
END;
-----------
Can any one help me.
Thanks in advance..
Regards,
Anjan