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:
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)