I am using SQL Executor for fetching geometry and associated attributes(stored as a single row records in a table) from a table based on value parameters which I pass to SQLExecutor query, the SQL statement in the SQLExecutor goes like.
select * from ftablename] where hattribute]=@valuevattribute] and attribute]=@value@attribute]
When I execute this query to generate attributes to expose it gives me ORA-00936 missing expressions error. But if I continue the execution without it it fetches the desired geometry minus its attributes. If I mention to fetch attributes in the SQL statement instead of *, it fetches the attributes but not the geometry.
I've tried using Joiner but it doesn't get geometries.
This transformer is giving me a very hard time, can anybody please help me on this.
IMRAN