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
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 Tue Feb 19 2002 - 20:23:21 CST