It is possible to see the plsql warnings in SQL Navigator?
Please see an example below:
open a SQL Plus session and modify the session as shown below:
ALTER SESSION SET PLSQL_WARNINGS='ENABLE:ALL';
Then create the procedure below:
CREATE OR REPLACE PROCEDURE showErrors IS
BEGIN
IF 1=2 THEN null; END IF;
END showErrors ;
/
You got the error:
SP2-0804: Procedimiento creado con advertencias de compilaci¾n
If you type show errors;, you get the detail of the warning :
Errores para PROCEDURE SHOWERRORS:
LINE/COL ERROR
-------- -----------------------------------------------------------------
1/1 PLW-05018: unit SHOWERRORS omitted optional AUTHID clause;
default value DEFINER used
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback 이용 약관 개인정보 보호정책 Cookie Preference Center