2 Replies Latest reply on Jun 17, 2014 12:02 PM by Kirk Fritsche

    Changing sql array fetch size per query or worksheet

    Kirk Fritsche

      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.