Hi everybody.
I dont understand how to work properly with plsql warnings in pl/sql developer
TASK:
I want to see all plsql warnings during compiling of my program units.
1. I enabled all warnings 'alter system set plsql_warnings="enable:all"'
2. I restarted instance.
3. I opened sql plus and check next code
CREATE OR REPLACE PROCEDURE Test2 AS
v NUMBER := 1;
BEGIN
IF v = 1 THEN
Dbms_Output.Put_Line('No');
ELSE
Dbms_Output.Put_Line('Yes');
END IF;
END;
and I saw "Procedure created with compilation warnings"
5. Then "show err"
and i got 2 errors PLW-05018 and PLW-06002
6. I started PL/SQL developer and in Preferences->Compiler->PLSQL Warnings set parematers Action=Warning and Exception=All
7. I restarted PL/SQL Developer
8. I opened program window and recreated the procedure
I got only PLW-05018 warning(which is not available in pl/sql developer warning list).
9. I opened command window and recreated the procedure
First I saw only "procedure created"
but after typing "show err" i saw 2 warnings like in sql plus
So
1. How can i get all warnings in program window?
2. Why there is no any warning about PLSQL WARNINGS in command window?
Oracle - 11.2.0.1
PL/SQL Developer - 11.0.4.1788 64bit
I dont understand how to work properly with plsql warnings in pl/sql developer
TASK:
I want to see all plsql warnings during compiling of my program units.
1. I enabled all warnings 'alter system set plsql_warnings="enable:all"'
2. I restarted instance.
3. I opened sql plus and check next code
CREATE OR REPLACE PROCEDURE Test2 AS
v NUMBER := 1;
BEGIN
IF v = 1 THEN
Dbms_Output.Put_Line('No');
ELSE
Dbms_Output.Put_Line('Yes');
END IF;
END;
and I saw "Procedure created with compilation warnings"
5. Then "show err"
and i got 2 errors PLW-05018 and PLW-06002
6. I started PL/SQL developer and in Preferences->Compiler->PLSQL Warnings set parematers Action=Warning and Exception=All
7. I restarted PL/SQL Developer
8. I opened program window and recreated the procedure
I got only PLW-05018 warning(which is not available in pl/sql developer warning list).
9. I opened command window and recreated the procedure
First I saw only "procedure created"
but after typing "show err" i saw 2 warnings like in sql plus
So
1. How can i get all warnings in program window?
2. Why there is no any warning about PLSQL WARNINGS in command window?
Oracle - 11.2.0.1
PL/SQL Developer - 11.0.4.1788 64bit