SQL & PL/SQL

Read Study Guide for

1Z0-144: Oracle Database 11g:Program with PL/SQL

Handling PL/SQL Errors

You can also treat particular messages as errors instead of warnings. For example, if you know that the warning message PLW-05003 represents a serious problem in your code, including 'ERROR:05003' in the PLSQL_WARNINGS setting makes that condition trigger an error message (PLS_05003) instead of a warning message. An error message causes the compilation to fail.

----

Ramin Hashimzade

Why are you asking?

If I were you, I would just try out, and see wat happen.

Thanks for your reply.

I dont know how to test this scenario.Can you tell me the codes how to try/test the same.

Have a look at this page from the doumentation.

(search for severe)

Then you can create your on test-code.

Which document?

This:

Oracle Database Online Documentation 11g Release 2 (11.2)

(use the search box)

the 2-Day Developers Guide would be a good starting point to explore: Contents along with the SQL reference: Contents

I am not able to find the answer from the document.

Can you tell me what will be the answer for this and why(reason)?

Waiting for your help.

This should clear things up for you:

PLSQL_WARNINGS

PLW-05000 to PLW-07206

Hello Hoek,

From your ref. document what i understand answer will be-

C. It issues warnings whenever the code causes an unexpected action or wrong results performance problems.

Am i correct?

yes you are correct..whenever you will get performance issue it issues warnings with error msg  05003.

No, it is B, you'll get a compilation error, instead of a warning, your object will not compile:

SQL> ALTER SESSION SET plsql_warnings = 'enable:severe','enable:performance';

Session altered.

SQL> create function unreachable
  2  return varchar2
  3  as
  4   i_am_unreachable varchar2(1);
  5  begin
  6   return 'Y';
  7   i_am_unreachable := 'Y';
  8  end;
  9  /

SP2-0806: Function created with compilation warnings

SQL> sho err
Errors for FUNCTION UNREACHABLE:

LINE/COL ERROR
-------- -----------------------------------------------------------------
1/1      PLW-05018: unit UNREACHABLE omitted optional AUTHID clause;
         default value DEFINER used

SQL> ALTER SESSION SET plsql_warnings = 'enable:severe','enable:performance', 'ERROR:06002';

Session altered.

SQL> create or replace function unreachable
  2  return varchar2
  3  as
  4   i_am_unreachable varchar2(1);
  5  begin
  6   return 'Y';
  7   i_am_unreachable := 'Y';
  8  end;
  9  /

Warning: Function created with compilation errors.

SQL> sho err
Errors for FUNCTION UNREACHABLE:

LINE/COL ERROR
-------- -----------------------------------------------------------------
1/1      PLW-05018: unit UNREACHABLE omitted optional AUTHID clause;
         default value DEFINER used

7/2      PLS-06002: Unreachable code
SQL>

Message was edited by: Hoek I just noticed: Ramin already pointed this out in the first reply you got on your thread. Hope it is all 100% clear now.