Re: Sorting with Forms 5.0

From: Paul Dorsey <pdorsey_at_dulcian.com>
Date: Sat, 31 Jul 1999 05:01:14 GMT
Message-ID: <uqvo3.81602$eF3.25820_at_news.rdc1.nj.home.com>


Serdar:
You are right, you will need to use a PL/SQL table. Your table could retrieve the information and store it in a package table, then on reexecution you could just resort the data within the procedure that builds the block.

But I think you are probably doing the unnecessary. Unless your query is very complex and takes a long time to run, a requery is usually not bad in this context..

--
Paul Dorsey
Dulcian, Inc.
www.dulcian.com
212 595 7223
Serdar Yorgancigil wrote in message <379E8F6D.AE0CB70B_at_usa.net>...

>Hi everyone,
>
>I have multirow database block and some queried data in it. I want to
>sort the block without executing the query again. And the block has to
>be sorted according to the users choice.
>
>I think pl/sql table can be used. But I wonder if anybody has a better
>suggestion.
>
>Thanks in advance...
>
Received on Sat Jul 31 1999 - 07:01:14 CEST

Original text of this message