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
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center