I have a pipelined table function, used for debugging, which does some work over a potentially long period of time where pipe row is called periodically throughout the execution.
If the preferences for the sql array fetch size is set to 1 then the result tab shows each row as it is piped out which is exactly what I want.
For general development I prefer a value of 500.
Is there a way to set this value within a SQL Worksheet so that I don't have to navigate through the preferences window and then reset my connection?
I tried using the SQL*Plus set arraysize, but that had no effect on the query result window and running as a script was not useful either.