oracle jdbc query across a database link
I am having a problem with my sql query that queries data in two different databases via a database link.
e.g.
get fdb.this, fdb.that from firstdb fdb
join view.sceonddb@dblink sdb on
fdb...
Forum Discussion
What type of step did use? Is it Jdbc step or groovy? Noticed any errors in log files?
dbSource step.
I reworked my query and got it to work.
Can you please tell me how to look up the sql logs for a JDBC dataSource step? I am finding it really difficult to debug these steps. Also, I would like to transfer properties into the prepared properties for this type of step and I just am not seeing how to do that.