Toad World® Forums

ho ho ho, major TOAD crash bug with MDSYS.GEORASTER object table


#1

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


#2

What version of Oracle server and client are you using?