Using Oracle Ref Cursors in a DTS Package

#1

Howdy,

I need to call an Oracle package, that does some process on a Oracle
Database and outputs 0 or more rows in a ref cursor. Is it possible to call
this oracle Package in a DTS Package and to insert the returned ref cursors
rows in to a SQL 2K DB Table ?

I am connecting to the Oracle DB via OLEDB. If I cant use DTS, has anyone
any ideas for for ways to batch up this call to the Oracle Package on a
nighly basis.
Cheers
A

#2

Just to clarify I am trying to execute a procedure in a oracle package. Any
idea anyone ? Has no one done this before, am I the first ..... Help!
"Ado" <Adrian_donnelly (AT) hotmail (DOT) com> wrote

Quote:

Howdy,

I need to call an Oracle package, that does some process on a Oracle
Database and outputs 0 or more rows in a ref cursor. Is it possible to
call this oracle Package in a DTS Package and to insert the returned ref
cursors rows in to a SQL 2K DB Table ?

I am connecting to the Oracle DB via OLEDB. If I cant use DTS, has anyone
any ideas for for ways to batch up this call to the Oracle Package on a
nighly basis.
Cheers
A

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Using Oracle Ref Cursors in a DTS Package

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Using Oracle Ref Cursors in a DTS Package - 01-04-2005 , 12:00 PM

Re: Using Oracle Ref Cursors in a DTS Package - 01-06-2005 , 04:17 AM