Passing values from other querys value to another query (different databases)

Hi,

I have a query from oracle database:
select order from orderno

results for instance
1234
1763
1452

Then I would like to pass those values from column 'order' to MS SQL query:
select number from numberorder where number in ('--values from oracle query')

Should I do this with parameters, but how?