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

Create an odbc connection. I used MS SQL Server ODBC driver, but Intersolv works too. When connecting, host string is :

odbc:my_connection

Where my_connection is the odbc connection that you created

Paul

"Vladimir M. Zakharychev" <bob_at_dpsp-yes.com> wrote in message news:<a52jlb$6kp$1_at_babylon.agtel.net>...
> 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...
> > 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:22:35 CST