Problems to call procedure and return of an outputvar
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 (?)}"
SET tSC = ..Adapter.ExecuteProcedure (, .Outparm, SQLQuery, "o *", Inparm)
This constantly creates errors. I have tried different variants but nothing works.
Outparm is always null or empty.
Greatful for help with the right syntax!
Sincerely, Michael