I am using DTS sql 7
How can I pass parameters using the lookups in DTS to access oracle database?
i know in sql u could do e.g

select company_ID from Company
where
Company_Desc = ?


but it won't work with oracle.

i have used
select company_ID from Company
where
Company_Desc = '&company_desc'

but it did not ask for a parameter.