db<>fiddle (Oracle): Query works in 18c, but not 21c

1 vote

2 answers

159 views

                          I have a Oracle query that I use to analyze the vertices of SDO_GEOMETRY polylines:

    WITH lines AS
     (SELECT SDO_UTIL.FROM_WKTGEOMETRY('MULTILINESTRING ((0 5 0, 10 10 10, 30 0 33.54),(50 10 33.54, 60 10 -10000))') tline
       FROM dual)
    SELECT ct.id,ct.x, ct.y, ct.z as clcorr, vt.z as clorig
     FROM lines,
     TABLE(sdo_util.getvertices(SDO_LRS.CONVERT_TO_LRS_GEOM(SDO_CS.make_2d(tline)))) ct
     JOIN table(sdo_util.getvertices(tline)) vt
       ON ct.id=vt.id;

Source: Find polyline vertices where M-value is not cumulative length 

------

That query works in dbfiddle for Oracle **18c**:

 - [Screenshot](https://i.sstatic.net/vPLGM.png) 
 - [Fiddle](https://dbfiddle.uk/?rdbms=oracle_18&fiddle=6afc20f0c18d8f740cb711d8eb0cc9f1) 

But the same query produces an error in dbfiddle for Oracle **21c**:

    ORA-00904: "CT"."Z": invalid identifier
 - [Screenshot](https://i.sstatic.net/JSdyh.png) 
 - [Fiddle](https://dbfiddle.uk/?rdbms=oracle_21&fiddle=6afc20f0c18d8f740cb711d8eb0cc9f1) 

-------

Why doesn't the query work in dbfiddle for Oracle 21c?


                        

Asked by User1974 (1527 rep)

Apr 14, 2022, 03:28 AM
Last activity: Jul 2, 2022, 07:22 AM

db<>fiddle (Oracle): Query works in 18c, but not 21c

Related Questions