Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Calling Stored Procedure using DTS
If that don't work, try
"BEGIN CIBONYXEXTRACT ('01-JAN-00','17-AUG-00');END;"
Just a guess.
"Roger Palmen" <r.palmen.ani_at_alewijnse.nl> wrote in message
news:399D03D4.671BFEFC_at_alewijnse.nl...
> 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 - 07:04:25 CDT