Hello
I have trouble capturing the value from a stored procedures output variable from an MS SQL Database.
In the database querywindow of MS SQL manager, the procedure is called as:
declare @return As varchar (100)
Execute TheProcedure @return. @return then contains string of content.
From HC I call the procedure:
set RetValue = ""
set Inparm = "@return"
set Outparm = ## class (% ListOfDataTypes).% New ()
SET SQLQuery = "exec TheProcedure ?"
(have also tried
"{call TheProcedure (?)}"