View Issue Details

IDProjectCategoryView StatusLast Update
0004560SymmetricDSImprovementpublic2022-08-01 20:18
Reporterdingshiuan Assigned Toelong  
Prioritynormal 
Status closedResolutionno change required 
Product Version3.12.3 
Summary0004560: function SYM_WKT2GEOM is invalid
Descriptionfunction SYM_WKT2GEOM on Tibero database
but it is invalid status, how to make it valid ?
Steps To ReproduceRecompile it :
CREATE OR REPLACE FUNCTION STORE.SYM_WKT2GEOM( clob_in IN CLOB)
RETURN SDO_GEOMETRY AS v_out SDO_GEOMETRY := NULL;
BEGIN
IF clob_in IS NOT NULL THEN
    IF DBMS_LOB.GETLENGTH (clob_in) > 0 THEN
    v_out := SDO_GEOMETRY (clob_in);
    END IF;
 END IF;
 RETURN v_out;
 END sym_wkt2geom;
 /
Warning: FUNCTION created with compilation errors.

SQL> show error
Errors for Function STORE.SYM_WKT2GEOM:

ERROR DESCRIPTION
--------------------------------------------------------------------------------
TBR-15044: Undefined identifier 'SDO_GEOMETRY'.
at line 2, column 8 of null:
RETURN SDO_GEOMETRY AS v_out SDO_GEOMETRY := NULL;
       ^^^^^^^^^^^^
TagsNo tags attached.

Activities

dingshiuan

2020-09-19 04:06

reporter  

image.png (29,087 bytes)   
image.png (29,087 bytes)   

dingshiuan

2020-09-22 15:38

reporter   ~0001775

Dear Sir

could you help this issue ?
thanks a lot ~

dingshiuan

2020-09-22 23:25

reporter   ~0001776

Invalid function is on Target / Tibero database

dingshiuan

2020-09-23 16:34

reporter   ~0001777

So far, Tibero may not support Spatial SDO_GEOMETRY function, so Please close this issue
thanks a lot ~

Issue History

Date Modified Username Field Change
2020-09-19 04:06 dingshiuan New Issue
2020-09-19 04:06 dingshiuan File Added: image.png
2020-09-22 15:38 dingshiuan Note Added: 0001775
2020-09-22 23:25 dingshiuan Note Added: 0001776
2020-09-23 16:34 dingshiuan Note Added: 0001777
2022-08-01 20:18 elong Assigned To => elong
2022-08-01 20:18 elong Status new => closed
2022-08-01 20:18 elong Resolution open => no change required