Re: Need assistance with Oracle 9i calling stored procedure on SQL Server via Gateway

Paul,

Thx for the response. A periodic replication / refresh of the data has been considered. By the by, my users may consider that option but they're much more desireous of truly real-time data. This data is subject to change where real-time is needed.

Thx again,

• S D R -
  >
  > Just a thought (and sorry if this doesn't help).
  >
  > How up-to-date does the query need to be? If not up-to-the-second, have you
  > considered using a simple SQLServer DTS job to replicate the data into
  > Oracle every few minutes? Then the Oracle query could stay in its own
  > sandbox, and no doubt perform much better, but of course the downside is
  > (potentially) stale data from the SQLServer side. Is this real-time, or
  > what?
  >
  > Tell more, and I'll try to help more.
  >
  > Regards,
  > Paul