View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0004560 | SymmetricDS | Improvement | public | 2020-09-19 04:06 | 2022-08-01 20:18 |
Reporter | dingshiuan | Assigned To | elong | ||
Priority | normal | ||||
Status | closed | Resolution | no change required | ||
Product Version | 3.12.3 | ||||
Summary | 0004560: function SYM_WKT2GEOM is invalid | ||||
Description | function SYM_WKT2GEOM on Tibero database but it is invalid status, how to make it valid ? | ||||
Steps To Reproduce | Recompile 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; ^^^^^^^^^^^^ | ||||
Tags | No tags attached. | ||||
|
|
|
Dear Sir could you help this issue ? thanks a lot ~ |
|
Invalid function is on Target / Tibero database |
|
So far, Tibero may not support Spatial SDO_GEOMETRY function, so Please close this issue thanks a lot ~ |
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 |