Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
A syntax error in a execution
Message
From
09/07/2009 20:32:59
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Title:
A syntax error in a execution
Environment versions
SQL Server:
SQL Server 2000
Application:
Desktop
Miscellaneous
Thread ID:
01411318
Message ID:
01411318
Views:
114
I triedn to execute teh following code:
DECLARE trabajador_cursor CURSOR
   FOR
   SELECT cod_emple FROM plplfmae WHERE condicion = 'ON'
OPEN trabajador_cursor
DECLARE @codigotrabajador varchar
FETCH NEXT FROM trabajador_cursor INTO @codigotrabajador
WHILE (@@FETCH_STATUS <> -1)
BEGIN

   EXEC ('PA_calculorem' @param1 = @codigotrabajador)
   FETCH NEXT FROM trabajador_cursor INTO @codigotrabajador
END


DEALLOCATE trabajador_cursor
and i got the following error message:

Servidor: mensaje 170, nivel 15, estado 1, línea 10
Línea 10: sintaxis incorrecta cerca de '@param1'.

Anyone can help me to find what i did wrong?
Thank you
Next
Reply
Map
View

Click here to load this message in the networking platform