Re: Getting array of rows from PL/SQL

For re-sort the detail data you can use Set_Block_Property function for set new ORDER BY clause and then do EXECUTE_QUERY or Do_Key('EXECUTE_QUERY').

I hope this help.

Adrian Klingel wrote:
>
> This sounds like a good idea to improve some performance in an Oracle Forms 5.0
> app I'm working on. I have a master-detail form where the user can re-sort the
> detail data by clicking on the column heading. Could I use this instead of
> requerying everytime providing the detail information can't be manipulated in any
> way? What is the largest size a PL/SQL table can be. When is it too large to
> perform well? Thanks alot!
>
> Adrian
 

-- 
Valery A. Sorokin
ProSoft, Russia, Moscow