Long standing Schema Browser issue with MDSYS.SDO_GEORASTER objects

Toad for Oracle & DevOps Toolkit
1

Hi folks,

I was using TOAD 12.8.4.9 recently and noticed that my bug I reported a half decade ago is still quite active.
https://www.toadworld.com/products/toad-for-oracle/f/10/t/9913

I was wondering if there was any progress on the matter, it’s a bummer when TOAD crashes. With the old TOAD 10, the schema browser would crash the moment a georaster object was viewed. With TOAD 12, viewing the georaster object in the schema browser seems on first blush to work (unless you expressly try and click on the metadata attribute at the end of the object) but soon after doing so TOAD will begin tossing errors left and right usually

6765.Capture.png

with a helping of “nil font” messages. It seem like as with version 10 five years ago to be related to the schema browser simply not liking the embedded SYS.XMLTYPE in the georaster object.

Thanks,

Paul

DROP TABLE foo;
DROP TABLE foo_rdt;

CREATE TABLE foo(
rasterid INTEGER
,theraster MDSYS.SDO_GEORASTER
);

CREATE table foo_rdt OF MDSYS.SDO_RASTER;

INSERT INTO foo VALUES(
1
,MDSYS.SDO_GEORASTER(
20001
,MDSYS.SDO_GEOMETRY(
2003
,8265
,NULL
,MDSYS.SDO_ELEM_INFO_ARRAY(
1
,1003
,1
)
,MDSYS.SDO_ORDINATE_ARRAY(
-88.2911459212039,42.7437506014213
,-88.3049939664713,42.619476899525
,-88.3187924563978,42.4952233772097
,-87.6739547352555,42.4554377139682
,-87.0302499445513,42.4124846902188
,-87.0141623430339,42.5365760510931
,-86.9980171033403,42.6606865292206
,-87.6443772184359,42.7038318721578
,-88.2911459212039,42.7437506014213
)
)
,‘FOO_RDT’
,78
,SYS.XMLTYPE(’<georasterMetadata xmlns="xmlns.oracle.com/…/totalDimensions><dimensionSize type=“ROW”>929352446729103257REGULAR828128128BSQNONENONEtruetrue50703030CENTERFunctionalFitting120712 -0 -0.03333333333333333182365 0.03333333333333333 -01BAND00255’)
)
);
COMMIT;

2

In the original post, John asked for the oracle server version. Also, can you attach the call stack (click here on the error dialog). Without further information, we can't diagnose the issue.

Thanks,

Greg

On Jan 2, 2016, at 12:46 PM, Paul Dziemiela bounce-pdziemiela_781@toadworld.com wrote:

Long standing Schema Browser issue with MDSYS.SDO_GEORASTER objects

Thread created by Paul Dziemiela
Hi folks,

I was using TOAD 12.8.4.9 recently and noticed that my bug I reported a half decade ago is still quite active.

https://www.toadworld.com/products/toad-for-oracle/f/10/t/9913

I was wondering if there was any progress on the matter, it's a bummer when TOAD crashes. With the old TOAD 10, the schema browser would crash the moment a georaster object was viewed. With TOAD 12, viewing the georaster object in the schema browser seems on first blush to work (unless you expressly try and click on the metadata attribute at the end of the object) but soon after doing so TOAD will begin tossing errors left and right usually

with a helping of "nil font" messages. It seem like as with version 10 five years ago to be related to the schema browser simply not liking the embedded SYS.XMLTYPE in the georaster object.

Thanks,

Paul

DROP TABLE foo;

DROP TABLE foo_rdt;

CREATE TABLE foo(

rasterid INTEGER

,theraster MDSYS.SDO_GEORASTER

);

CREATE table foo_rdt OF MDSYS.SDO_RASTER;

INSERT INTO foo VALUES(

1

,MDSYS.SDO_GEORASTER(

20001

,MDSYS.SDO_GEOMETRY(

   2003

  ,8265

  ,NULL

  ,MDSYS.SDO_ELEM_INFO_ARRAY(

       1

      ,1003

      ,1

   )

  ,MDSYS.SDO_ORDINATE_ARRAY(

       -88.2911459212039,42.7437506014213

      ,-88.3049939664713,42.619476899525

      ,-88.3187924563978,42.4952233772097

      ,-87.6739547352555,42.4554377139682

      ,-87.0302499445513,42.4124846902188

      ,-87.0141623430339,42.5365760510931

      ,-86.9980171033403,42.6606865292206

      ,-87.6443772184359,42.7038318721578

      ,-88.2911459212039,42.7437506014213

   )

)

,'FOO_RDT'

,78

,SYS.XMLTYPE('<georasterMetadata xmlns="xmlns.oracle.com/.../totalDimensions><dimensionSize type="ROW">929352446729103257REGULAR828128128BSQNONENONEtruetrue50703030CENTERFunctionalFitting120712 -0 -0.03333333333333333182365 0.03333333333333333 -01BAND00255')

)

);

COMMIT;

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

3

Thanks for the fast response!

I think I did discuss it directly with John and my memory is there was no fix possible, though I am not sure really of the details so long ago. Previously it was a fairly harmless bug that once it occurred, went away after clicking OK on the message. The new behavior is more onerous as it seem like TOAD goes into a bit of death spiral then needing a full application restart.

My hope was changes since then would have fixed the issue. The crash affects 10gR1, 10gR2, 11gR1 and 11gR2. Clients used include 10gR2, 11gR2 and 12cR1.

Thanks,

Paul

[View:/cfs-file/__key/communityserver-discussions-components-files/10/callstack.txt:320:240]

4

I’m trying to reproduce it but something’s wrong with that XML…or at least Oracle thinks there is…when it tries to insert the row, I get:

ORA-31011: XML parsing failed

ORA-19213: error occurred in XML processing at lines 1

LPX-00244: invalid use of less-than (’<’) character (use <)

ORA-06512: at “SYS.XMLTYPE”, line 310

ORA-06512: at line 1

5

Hi John,

Indeed, it appears the TOAD forum has some kind of line length limitation whereby instead of telling you the line is too long or truncating the backside, it adds “…” in the midst of the quoted text. Yikes, no design awards for that feature.

Here is the same script as a GIST.

gist.github.com/…/59d8e32c669d6b2053a6

Cheers,

Paul

6

Thanks Paul. I got the row inserted and I can reproduce the problem.

7

It is the XMLTYPE field inside the SDO_GEORASTER column that is giving Toad fits. XMLTYPE still isn’t supported but hopefully next beta, Toad will handle it a little better if you click on the data tab for this table and scroll over to where the XMLTYPE field is.