One of our dba’s - he is new in this job - wracked the view…
But they have fixed it now.
Thanks to all for your help!
Von: firstname.lastname@example.org [mailto:email@example.com] Im Auftrag von Gregory
Gesendet: Dienstag, 4. Mai 2010 19:39
Betreff: RE: [toad] av in 10.1 and 10.5: Could not convert variant of type
(UnicodeString) into type (Double).
I think that explains it. That column is supposed to be a NUMBER column. Or at
least that’s what Larry says.
Column Datatype NULL Description
POSITION NUMBER NOT NULL If DATA_LEVEL is zero, then this column holds the
position of this item in the argument list, or zero
for a function return value. If DATA_LEVEL is greater
than zero, then this column holds the position of this
item with respect to its siblings at the same DATA_LEVEL.
So, for a referenced record field, this is the index of
the field within the record. For a referenced collection
element, this is 1 (because collection elements do not have siblings.)