Claus Pedersen
Member³
I have the following code:
When compiled, the hint says that parameter empno is never used. But it is used, it is just prefixed with the cursor name.
Syntax highlight is also confused, it can not highlight the cursor variable correctly
When my_cursor.empno is written as my_cursor. empno (with a space after the dot) everything works fine.
Code:
CURSOR my_cursor (empno IN emp.empno%TYPE) IS
SELECT *
FROM emp
WHERE emp.empno = my_cursor.empno;
When compiled, the hint says that parameter empno is never used. But it is used, it is just prefixed with the cursor name.
Syntax highlight is also confused, it can not highlight the cursor variable correctly
When my_cursor.empno is written as my_cursor. empno (with a space after the dot) everything works fine.