Question

Merging two geometries in same feature

  • 24 June 2013
  • 1 reply
  • 3 views

Badge
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.

 


1 reply

Userlevel 4
Hi,

 

 

this is an Oracle limitation, it is not directly related to FME.

 

 

You can google "ORA-01704" and see.

 

 

In my opinion: it is not trivial to work around, but probably doable.

 

 

The problem is that FME does not use bind variables in the SQLExecutor or the ArcSDEQuerier (and perhaps others).

 

 

David

Reply