Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Calling Stored Procedure using DTS

Re: Calling Stored Procedure using DTS

From: Mark G <markag_at_wonderstats.com>
Date: Fri, 18 Aug 2000 08:04:25 -0400
Message-ID: <F4155D9F9AA4D111B9990020AFBA52D53F68CA@class06.ip061.sfi-software.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US