Errors when creating Vvews with PL/SQL functions in the with clause

[Marcel Hoefs]

PL/SQL Dev version 13.0.0.1873

Views with PL/SQL functions in the with clause cannot be created in this version. This was also the case in version 12.

E.g.

CREATE OR REPLACE VIEW test_view AS
WITH
  FUNCTION fd
  (p_datum IN DATE
  )
  RETURN VARCHAR2
  IS
  BEGIN
    RETURN TO_CHAR(p_datum,'DD-MM-YYYY');
  END fd;
SELECT fd(SYSDATE) datum
FROM dual
/

produces the following errors in a SQL window:

[image]https://imgur.com/pWkUg9G[/image]

In a command window you get these errors:

[image]https://imgur.com/2sGxQy3[/image]

In SQL*Plus this statement is processed without any errors and the view is valid afterwards.

Please fix this limitation in version 13.

Thank you.

 

[Marco Kalter]

We'll fix it.

 

[Marcel Hoefs]

Fixed in PL/SQL Dev version 13.0.0.1874 (= beta 4)

Excellent work!