You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.

Execute stored procedure from SQR

No replies
Guest's picture
Guest

I have a stored procedure that must do insert on link server, I have the following code that execute the stored procedure:

Begin-SQL On-Error=SQL-Error
EXECUTE SP_JDEEmployee $Emplid $Name $JDE-Julian
End-SQL

I get the following error on executing the SQR

SQL Status = 16954, SQL Error = [Microsoft][SQL Server Native Client 10.0][SQL Server]Executing SQL directly; no cursor.

Post new comment

CAPTCHA
The question below is to prevent automated spam submissions.
5 + 0 =
Solve this simple math problem and enter the result. E.g. for 1+3, enter 4.