Re: Calling Stored Procedure using DTS

Try "CALL CIBONYXEXTRACT ('01-JAN-00','17-AUG-00')"

I am not certain it works for you, but it worked for me.

markhostetler_at_usa.net wrote:

> 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 Fri Aug 18 2000 - 04:37:24 CDT