Manipulating collections using insert/select

Hello,

I want to know whether it is possible to manipulate collections using SQL insert and select?

Please take a look at these definitions:

CREATE OR REPLACE TYPE BEREGN_RESULTAT_OBJECT AS OBJECT  (

 ID                                       NUMBER(32)


 ,PERIODE_FRA                              DATE


 ,PRIS                                     NUMBER

and

CREATE TYPE FOUND_BEREGN_RESULTAT AS TABLE OF BEREGN_RESULTAT_OBJECT; Now I want to sort a collection (this example does NOT work):

declare

    source FOUND_BEREGN_RESULTAT;
    dest FOUND_BEREGN_RESULTAT;
begin

• Fill the source table....... ... ...
• Sort it: insert into dest select * from source order by period_fra; end;

But it does not work! ?

Does anybody know how to achieve this effect without having to store the collection in a temporary database table?

Thanks,
Johan Received on Thu Aug 26 1999 - 09:08:58 CDT