ALTER SESSION SET PLSQL_WARNINGS='ENABLE:ALL';
set serverout on feedback on verify on
select PLSQL_WARNINGS from DBA_PLSQL_OBJECT_SETTINGS where where owner='ABC' and name='XYZ';
set serverout on feedback on verify on
select PLSQL_WARNINGS from DBA_PLSQL_OBJECT_SETTINGS where where owner='ABC' and name='XYZ';