Hi everyone,
Can someone let me know if there's a way of calling Oracle's procedure
within a SQL Server DTS package please. If there is a way, an example would
be greatly appreciated.
The reason for this is that I need to execute the Oracle procedure to
extract data from Oracle tables, then manipulate the data and dump the data
into a temporary table which then get exported to SQL Server via DTS package.
Or if there is a better option for doing this, I'd more than happy to try.
Thanks so much in advance.
KD

Calvin,
Just curious if you ever figured this problem out. A coworked of mine has
the same issue and we'd like to know how to execute the Oracle sp from a DTS
package.

Thanks

Dave

"Calvin KD" wrote:

Hi folks,

"dcyr" wrote:
AFAIK the limitation exists because the SQL Server rely on schema
informations for optimizing the query.
The procedures or packages doesn't return schema informations and therefor
cause an error.
You can workaround this problem - where this is suitable - with an explicit
call of the oracle package through ADO inside of an activeX task.
See the following KB article for an example and description.
http://support.microsoft.com/default...b;en-us;176086
But you should always remember, that the actual oracle provider is based on
Oracle 7 with limited support of Oracle8 extensions and nothing nowing
about 9 and 10 ;-)
With .Net you are more up to date, but can't use it inside of DTS or SQL
Server in general.

HTH
Helge