Saturday, June 4, 2011

How to check warnings at time of compilation ? (plsql warnings)

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';

No comments:

Post a Comment