Re^3: Oracle Db Link Error ORA-01001: invalid cursor

What is the relationship between id and linkname, is it 1 to 1, 1 to many or many to 1 ?

poj

Comment on Re^3: Oracle Db Link Error ORA-01001: invalid cursor

Replies are listed 'Best First'.
Re^4: Oracle Db Link Error ORA-01001: invalid cursor by mediocremorsov (Initiate) on Jan 11, 2017 at 13:58 UTC
it is 1 to many. 1 id to many dblinknames	[reply]
Re^5: Oracle Db Link Error ORA-01001: invalid cursor by poj (Abbot) on Jan 11, 2017 at 14:34 UTC
I would perhaps try running the first 2 queries and storing the results before running the 3rd query. As an example Read more... (2 kB)	[reply] [d/l]