PL/SQL (MOSC)

MOSC Banner

When it compiles with debugging information, Isn't it optimized?

edited Feb 15, 2012 6:21PM in PL/SQL (MOSC) 1 commentAnswered
 When it compiles with debugging information, Isn't it optimized? 
1) 11.2.0.2  At the time of the compile in those without debugging information 

SQL> ALTER SESSION SET PLSQL_DEBUG = FALSE
2 /

セッションが変更されました。

SQL> select name, value from V$PARAMETER
2 where name = 'plsql_optimize_level'
3 /

NAME
------------------------------------------------------------------------------

VALUE
------------------------------------------------------------------------------

plsql_optimize_level
2


SQL> create or replace
2 procedure ttt is
3 v_code NUMBER;
4 v_errm VARCHAR2(64);
5 BEGIN
6 IF TO_DATE('20112233','YYYYMMDD') > SYSDATE THEN
7 NULL;
8 END IF;
9 EXCEPTION
10 WHEN OTHERS THEN
11 v_code := SQLCODE;
12 v_errm := SUBSTR(SQLERRM, 1, 64);
13 DBMS_OUTPUT.PUT_LINE('Error code ' || v_code || ': ' || v_errm);
14 END;
15 /

プロシージャが作成されました。

SQL> set serveroutput on

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center