Problem with oracle Tabel

[ak77]

Hi,

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

ORAOCI8_119: Table Name is a required link property for Link

can someone help me with this?

Thanks
Kishan

[loveojha2]

Have you provided anything into the table names field of the stage? It requires this, i think Ray answered about it, stating

it uses the table name to validate the columns in your design when the connection to the database is established but before the request to prepare the SQL is issued.

Check this thread viewtopic.php?t=96581 for this.

If you haven't fill it with a table name(it need not be actual table name).

Hope this will solve your problem.

[ak77]

Hi love,

i figured that out and got rid of the problem but the problem for which i started is not yet solved

thanks for your reply

I will look into this but the tablename problem is taken care

Kishan