Hi folks,
Using Toad 10.6.1.3.
CREATE TABLE test_foo
(
GEORASTER_ID NUMBER(38),
GEORASTER_DESCRIPTION VARCHAR2(40 BYTE),
GEORASTER MDSYS.SDO_GEORASTER
);
So far so good. Now insert some data into the table
INSERT INTO test_foo VALUES(
1,
‘Conterminous US’,
MDSYS.SDO_GEORASTER(
20001,
MDSYS.SDO_GEOMETRY(2003,1000001,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SD
O_ORDINATE_ARRAY(-2356635,3166605,-2356635,1692030,-2356635,217485,100980,217485,
2558565,217485,2558565,1692030,2558565,3166605,100980,3166605,-2356635,3166605)),
‘FLOW_DIRECTION_CONT_US_RDT1’,
1,
XMLTYPE(’
20001
false
1
1
1
UNDEFINED
8BIT_U
2
98304
163840
0
0
REGULAR
384
640
256
256
BIP
DECREASE
NN
10
NONE
true
true
1000001
30.0
30.0
CENTER
FunctionalFitting
rowScale=“1.0” columnScale=“1.0” xScale=“1.0” yScale=“1.0” zScale=“1.0”>
105553.0 0.0
-0.03333333333333333
1.0
78554.0 0.03333333333333333 0.0
1.0
BAND
')
)
);
COMMIT;
From this point on if you try to view the table with the data tab or select the
georaster object from the table, TOAD completely and utterly crashes with
“Access violation at address 000000FF. Write of address 00407D34.”.
It seems tied to the XMLTYPE which is embedded in the object as an attribute. If
I NULL the XML attribute then its fine.
Cheers and Happy Holidays,
Paul