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 Thu Feb 21 2002 - 20:15:30 CST
