Is there any method / syntax that would allow me to run simple SQL PL scripts via Data Studio? I most recently saw a posting about this from 4-5 years ago. I need to avoid using stored procedures.
A simplistic example (that runs fine via the command line processor):
set serveroutput on@
declare counter int default 0;
while counter < 10 do
call dbms_output.put_line ('Counter: '||counter);
set counter = counter + 1;
This won't run as-is in a Data Studio SQL window.
If I strip it down so it is literally just
that runs without error - but obviously doesn't do anything.