I am using an User_defined query and this Oracle OCI plug-in is used as the reference for a look up
I tried using Hash file since the table has a composite key and i need only one of the field to be used for lookup, its removing duplicates based on the single column key
now when using the OCI plugin as refence file for lookup, i am getting this error
My query is
Select field1, field2, field3, field4
from tablename tbname
where tbname.field2 =:1 and tbname.field4 is not null
can someone help me with this?ORAOCI8_119: Table Name is a required link property for Link
Thanks
Kishan