Question
Problem in returning SDO_GEOMETRY from oracle function/procedure
I am able to read geometry from oracle but how can i return geometry from oracle function and expose it in FME 2012?
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
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.