PL/SQL compilation fails with no error message
I know this answer is kind of late but just want to let you know that you can also use:
ALTER PACKAGE your_package_name_here COMPILE PACKAGE;
ALTER PACKAGE your_package_name_here COMPILE BODY;
then if warning was shown, you can use the below script to check the error and which lines it resides in:
-- this shows the errors within the package itself
SHOW ERRORS PACKAGE your_package_name_here;
-- this shows the errors within the package body
SHOW ERRORS PACKAGE BODY your_package_name_here;
Conn as FLOWS_020000 and go:
SELECT *
FROM ALL_ERRORS
WHERE OWNER = USER;
Or conn as SYSTEM and go
SELECT *
FROM ALL_ERRORS
WHERE OWNER = 'FLOWS_020000';