Problem in returning SDO_GEOMETRY from oracle function/procedure

Hi,

 

 

have a look at this similar question. You will basically have your function return the geometry either as a WKB (blob) or WKT (varchar) object, then convert it back into a proper geometry using a GeometryReplacer in FME.

 

 

David

Thanks David, above approach works. But reverse is not working. In my flow, i created a geometry,say X using this approach and going on again created another geometry,say Y. when i try to verify geometries created in inspector, i can only see last geometry.

 

 

Is it like only one geometry can exists in one fme feature?

 

 

My task is to merge both geometries into one and insert into data base. I tried  following query.

 

'SELECT SDO_UTIL.APPEND(SDO_UTIL.FROM_WKTGEOMETRY(X_wkt),SDO_UTIL.FROM_WKTGEOMETRY(Y_wkt)) AS STROKED_GEOMETRY FROM DUAL'

 

rather got exception :

 

Error report:

 

SQL Error: ORA-01704: string literal too long

 

01704. 00000 -  "string literal too long"

 

*Cause:    The string literal is longer than 4000 characters.

 

*Action:   Use a string literal of at most 4000 characters.

 

           Longer values may only be entered using bind variables.

 

 

Any Suggestion will be very helpful.

 

 

Thanks in advance.