When the following error appears :
[1]:(Error): PLS-00371: at most one declaration for 'V_VARIABLE' is permitted
It would be very useful that SQL Navigator displays the first declaration of the variable
Steps to reproduce:
Compile the procedure below: You got the error PLS-00371: at most one declaration for 'V_VARIABLE' is permitted as expected .It would be great that SQL Navigator jumps to the first variable when clicking on the error message .Is that possible?
CREATE OR REPLACE PROCEDURE test_var
AS
var NUMBER;
var varchar;
BEGIN
SELECT 'test' INTO var FROM DUAL;
EXCEPTION
WHEN OTHERS
THEN
NULL;
END;
/
WORKAROUND
None
STATUS
Enhancement request PT41127543 has been submitted to Development for consideration in a future release of SQL Navigator for Oracle
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center