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;
/
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback 이용 약관 개인정보 보호정책 Cookie Preference Center