In my flow, i created a geometry,say X using this approach and going on again created another geometry,say Y in same feature. 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.