bug with sql-window

[sukhadukkham]

please try the following:

CREATE OR REPLACE TYPE ar_ts AS VARRAY(2147483647) OF TIMESTAMP(0) WITH TIME ZONE
/
CREATE TABLE TEST
(
  ts ar_ts
)
TABLESPACE BASIC
/
INSERT INTO test ( ts ) VALUES ( ar_ts ( TO_TIMESTAMP_TZ ( '01.01.2007 01:00:00 +01:00', 'DD.MM.YYYY HH24:MI:SS TZH:TZM' )
                                       , TO_TIMESTAMP_TZ ( '01.01.2007 02:00:00 +01:00', 'DD.MM.YYYY HH24:MI:SS TZH:TZM' )
                                       , TO_TIMESTAMP_TZ ( '01.01.2007 03:00:00 +01:00', 'DD.MM.YYYY HH24:MI:SS TZH:TZM' )
                                       )
                               )
/
COMMIT
/

no do a select on that table in the sql-window and try to step into the array-column. the result is empty. can you reproduce this?

regards
daniel

 

[Marco Kalter]

I get a strange ORA-message when I try to access this collection. We'll look into this.

 

[sukhadukkham]

thanks