Re: Multiple datasets in one dataset

Hi Brian,

sorry, that I did not answer your previous post completely. Your assumption (5a ... 5f) were all right.

The data gets be collected correctly.

After excessive testing I found out, that Oracle ends up in an endless loop when executing your fabulous statement  with data where CURR_MS and all other VALUE_N are filled with 0.

Maybe you could test it with the following sample data:

REM INSERTING into FOO
Insert into FOO
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',11,0,0,0,0,0,0,0,0,0,0,0); Insert into FOO
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',21,0,0,0,0,0,0,0,0,0,0,0); Insert into FOO
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',22,0,0,0,0,0,0,0,0,0,0,0); Insert into FOO
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',23,0,0,0,0,0,0,0,0,0,0,0); Insert into FOO
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',24,0,0,0,0,0,0,0,0,0,0,0); Insert into FOO
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',25,0,0,0,0,0,0,0,0,0,0,0); Insert into FOO
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',26,0,0,0,0,0,0,0,0,0,0,0);

I think we should be aware of such 0 values. What do you think?

Regards
Roman Received on Wed Oct 17 2007 - 08:36:47 CDT