Live ORACLE

if you are Oracle Developer ,than this Blog most likely will make you happy.

About my Blog

This Blog particularized for Oracle Developers ... you will see interesting Codes for SQL , PL/SQL as well as new ideas for Developer Suite and Client Tools that will help you in your professional life ... and I hope I reach for your satisfaction.

About Me

I'm Hany Freedom , 25 years old , I live in EL-Minia City in Egypt , I'm Moderator at ArabOUG.org the best Arabic Forum for ORACLE on the Net. if you interested to know more about me .... just Click Here.

Using the DBMS_WARNING Package to Display Warnings

-- When warnings disabled, the following procedure compiles with no warnings
CREATE OR REPLACE PROCEDURE Unreachable_code
AS
x CONSTANT BOOLEAN := true;
BEGIN
IF x THEN
dbms_output.Put_line('TRUE');
ELSE
dbms_output.Put_line('FALSE');
END IF;
END unreachable_code;
/

-- enable all warning messages for this session
CALL DBMS_WARNING.set_warning_setting_string('ENABLE:ALL' ,'SESSION');

-- Check the current warning setting
SELECT dbms_warning.Get_warning_setting_string()
FROM dual;

-- Recompile the procedure and a warning about unreachable code displays
ALTER PROCEDURE unreachable_code COMPILE;
SHOW ERRORS;



OUTPUT:-



you could have used the following ALTER PROCEDURE without the call to DBMS_WARNINGS.set_warning_setting_string:

ALTER PROCEDURE unreachable_code COMPILE PLSQL_WARNINGS = 'ENABLE:ALL' REUSE SETTINGS;

For more information, see ALTER PROCEDURE in Oracle Database SQL Reference,
DBMS_WARNING package in Oracle Database PL/SQL Packages and Types Reference, and
PLW- messages in Oracle Database Error Messages.
Share/Save/Bookmark

0 comments:

Post a Comment



Newer Posts Older Posts Home Page
 
http://www.dpriver.com/images/sqlpp-banner-2.png

Thanks for reading my Blog ... you Visitor Number :-