WinBatch Tech Support Home

Database Search

If you can't find the information using the categories below, post a question over in our WinBatch Tech Support Forum.

TechHome

ODBC
plus

Can't find the information you are looking for here? Then leave a message over on our WinBatch Tech Support Forum.

Get Parameters from a Stored Procedure

 Keywords:  qFetch Stored Procedure

Question:

By using the ODBC extender I am executing a stored procedure in my Microsoft SQL server;
DECLARE @r int
EXECUTE sp_mysp 'param1', 'param2', @result = @r OUTPUT
SET Result = @r
Now, how do I get the parameters into WinBatch, since this stored procedure is not returning a recordset I cannot use qFetch!

Anyone?

Answer:

You could:
Article ID:   W14774
File Created: 2017:07:28:12:58:32
Last Updated: 2001:11:08:11:39:56