Showing posts with label oracle plsql pl-sql compile warnings. Show all posts
Showing posts with label oracle plsql pl-sql compile warnings. Show all posts

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