Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Problem executing a SQL Server 2000 Stored Procedure from SQL*PLUS
I am more interested how you managed to connect to sql server with sql*plus :)
-- Vladimir Zakharychev (bob@dpsp-yes.com) http://www.dpsp-yes.com Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications. All opinions are mine and do not necessarily go in line with those of my employer. "Jim Kennedy" <kennedy-family_at_attbi.com> wrote in message news:tMDc8.7659$S01.492843_at_sccrnsc02...Received on Thu Feb 21 2002 - 04:57:58 CST
> 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
>
>