Hi, im using FME in an oracle database copying data from one table to another
I am trying to put a published parameter on a "WHERE clause..".
If i write the whole query, everything is OK:
"DE" in (SELECT CZ FROM REF_CZ WHERE MONO = 'BORË')':
but,
If i put a part of it as a published parameter i get this error:
Query: "DE" in (SELECT CZ FROM REF_CZ WHERE MONO = '$(P1)')
Field type is a string.
Error is : ORA-01756: quoted string not properly terminated'. (serverType=`ORACLE8i'..........