Calling Stored Procedure using DTS

From: <markhostetler_at_usa.net>
Date: Thu, 17 Aug 2000 22:53:18 GMT
Message-ID: <8nhqcn$14r$1@nnrp1.deja.com>

I am trying to sync some data from an Oracle system to a SQL system. I need to first call a stored procedure in the Oracle database that will populate the tables so I can extract them.

If I create a DTS package and make a connection to the Oracle datbase and an "Execute SQL Task" to run the stored procedure by giving it "Exec CIBONYXEXTRACT ('01-JAN-00','17-AUG-00')". I get the following error. "ORA-00900:invalid SQL statement"

If I run the same statement from the Oracle SQL plus window it runs perfectly.

Is there a way to get an Oracle stored procedure to run from a DTS package?
Is there any other way to call the stored procedure in Oracle from the MS SQL Server and then run the the DTS package?

Any help would be great.
Thanks

HOSS Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Aug 17 2000 - 17:53:18 CDT