Re: Problem executing a SQL Server 2000 Stored Procedure from SQL*PLUS

I'm fascinated by this ... exactly what is the real dollar difference between the two for your customer?

And what is the cost of rewriting the application and testing it?

Thanks.

Daniel Morgan

Paul Fell wrote:

> We have a client who has an oracle version of our product. He's fed up
> of the big $$$ he has to pay for the oracle licence. So the question's
> been asked can we port to sql server 2000? Try to forget all about the
> hype surrounding Oracle v SQL Server (difficult I know) and
> concentrate on the question which is - I have a Stored Procedure in
> SQL Server. Has anyone managed to execute a SQL Server Stored
> Procedure from SQL*PLUS? The connection is ms sql server odbc and
> works ok when doing SELECTS.
>
> Paul
> "Jim Kennedy" <kennedy-family_at_attbi.com> wrote in message news:<tMDc8.7659$S01.492843_at_sccrnsc02>...
> > You are using sql server that's your problem. :-)
> >
> > Seriously, why would you expect a stored procedure written for Oracle work
> > in SqlServer?
> > Jim
> > "Paul Fell" <novaweb_at_iinet.net.au> wrote in message
> > news:4b270a4e.0202191656.1a6b0723_at_posting.google.com...
> > > I have a stored procedure in SQL Server 2000 that takes three
> > > variables (all INPUT) varchar(200)). The SP updates another table. No
> > > Resultsets are returned.
> > >
> > > The same SP exists in Oracle (7.3)
> > >
> > > In SQL*PLUS connected to Oracle the following works fine :
> > >
> > > exec my_proc('test','test','test');
> > >
> > > But when I connect SQL*PLUS to SQL Server 2000 (Intersolv ODBC
> > > driver), it does not work. (the connection is fine because I can do a
> > > select on tables). I get an error message saying there is incorrect
> > > syntax near my_proc...
> > >
> > > What am I doing wrong?
> > >
> > > Paul
Received on Sat Feb 23 2002 - 09:17:08 CST