call stored procedure with output parameters from Wincc Flexible

Hello 

I would like to know how to call a stored procedure  in SQL from Wincc Flexible

the procedure works fine in SQL Server and it has 1 input and 1 output values

Thank you in advance 

Hello luismarcelo,

I guess you run a WinCC flexible application on a PC with a full Windows OS. Then this FAQ might help. There you find how to access an SQL database and how to run a querry.

Regards,

Frink

Hello Prof Frink

Thank you for your answer, I'am actually using the exmples recomended by SIEMENS with success to acceded SQL tables, but unfortunatelly I don't know how to adapt it to be able to call a stored prodecure

Hello luismarcelo,

how did you store the "procedure"? Is it a text-file, maybe with extention "sql"?

See: On a PC with WinCC flexible, how can you use a script to save and read out data in a text file?

Then you could read the sql-querry from the file and use it with the script described in the link of my first post here.

Regards,

Frink

Hello 

Stored procedure is a kind of "FUNCTION" resident on the sql server and writed in SQL lenguage.

It has a name and in SQL anvironmente is called by teh key word EXECUTE, adding the necesary parameters.

It is not a text file 

Thank you any way

Hi,

instead of blaming someone I recommend to post your issue/ question. No one knows, what information future users are searching for 

 Make sure your Sql query string should be the following format

strSQL = "EXEC ProcedureName " & "'" &Param1 & "', '" & Param2& "'"

 After that execute the Sqlcmd.
Before that your connection status configuration has to be done properly.

Hope This will useful for upcoming needs.

Thank you 

Baskar_Aj

Hello,

This is the Too Late, But I need this function Now. So I tried to found the solution for this topic.
Finally Got the Solution.

 Make sure your Sql query string should be the following format

strSQL = "EXEC ProcedureName " & "'" &Param1 & "', '" & Param2& "'"

 After that execute the Sqlcmd.
Before that your connection status configuration has to be done properly.

Hope This will useful for upcoming needs.

Thank you 

Thank you