Bug in PLSQL Beautifier.

[Alexandre]

Look at this exemple:

SELECT d.deptno AS departament_number,
         d.dname AS departament_name,
         d.loc AS department_location
    FROM emp  e,
       dept d
   WHERE e.empno  = p_empno
  AND d.deptno = e.deptno;

If you use the Beautifier it aligns everything correctly but, in this example:

CURSOR cTEST( p_empno NUMBER) IS
  SELECT d.deptno AS departament_number,
         d.dname AS departament_name,
         d.loc AS department_location
    FROM emp  e,
       dept d
   WHERE e.empno  = p_empno
 AND d.deptno = e.deptno;

The Beautifier doesnt work, simple ignore the line when you use it inside an Cursor.

 

[Marco Kalter]

It seems to work just fine for me. What exactly goes wrong?