Ok, I feel pretty dumb. I use PL to insert/update and other dml activities, but
I have an odd request which requires me to code PL to produce a data extract for
a user. I never had to use PL to select stuff to the grid.
I can’t seem to get the select statement to output to the grid.
execute immediate (‘select sysdate from dual’);
dbms_output. put_line (‘select sysdate from dual’);
Both execute, but no output to grid. To work around this, I created a temp
table, populate it with PL, then select * from temp. But my users have no create