I created a local package in Enterprise Manager for SQL 7.0 to retrieve data
from an Oracle database based on a field in one of my tables in SQL. I can't
figure out what expression or script I should use to identify the field and
then search Oracle based on that field. I am able to connect to the database
and search oracle based on a value I give it in the query manager. But,
the table in SQL will be updated daily and the new values in the table will
need to be used to search Oracle and pull it into a new table in SQL. Any
help would be appreciated.