Incomplete support of plsql in with clause - Allround Automations forums

I just noticed that the "Details" in the Sessions Tool does not support plsql in the with clause.
The "Filters" does support it.

This cost me quite a bit of time trying to figure out what was wrong with my query, and it turned out: nothing.
Because I already used the feature in the Filters without problem, I did not suspect that the Details does not support it.

Version: 15.0.3.2059

Test case:
1 - Create filter "Test Filter" with query:

SQL Query

with
  function try
  return varchar2
  is
  begin
    return 'SUCCESS !!';
  end;
  --
select try
from   dual

2 - Create detail "Test Details" with the exact same query

3 - Open Session Tool

You'll see "SUCCESS !!" selected in the filter part and "ORA-00905: missing keyword" in de Detail part. (See attached screenshot)

Attached picture plsqldev_sessions_tool.png

Attached picture plsqldev_sessions_tool.png

I tested this, and it seems that the statement is incorrectly truncated at the first semi-colon (after 'SUCCESS !!'). We'll fix it.

Fantastic. Thanks Marco!