Semicolon not allowed when using in-line functions, 12c

[Ivan C.]

Oracle 12c allows declaring named PL/SQL blocks in a query's WITH clause. For example:

with
  function z return int is
  begin
    return 0;
  end z;
select z from dual

In a SQL Window, in PL/SQL Developer 12.0.3.1821 (32-bit), a semicolon at the end of such query throws an error:

ORA-00933: SQL command not properly ended

When using a slash, everything works fine.

 

[Marco Kalter]

This is indeed a know restriction. Due to the PL/SQL block in the command you need to terminate it with a slash.

This is on the list of enhancement requests.