Execute store procedure in SQL database problems
Hi, I am trying to execute a store procedure within an ensemble operation to connect to aMsSQL database and I am having problem to pass the input arguments... I have tried several things but only one seems to work and it is not the ideal solution.
This is the code that works...as you can see the parameter is added to the sql query...not the best solution but the only that works at the moment.
SET tSC=..Adapter.ExecuteProcedure(,,SQLQuery,)
I have tried to call a store procedure that does not expect any parameters...and is also working:
SET tSC = ..Adapter.ExecuteProcedure(,,SQLQuery2,)
But when I am trying to do the call right based on the documentation...it is not working:
SET tSC = ..Adapter.ExecuteProcedure(,,SQLQuery3,,"aaaa")
What the ExecuteProcedure is returning is a error message that includes the following:
<Ens>ErrGeneraln SQLState: (HY001) NativeError: [0] Message: [Microsoft][ODBC SQL Server Driver]Memory allocation failure
Store procedure:
@HL7MSG varchar(max)AS
BEGIN
Looking at the documentation that call seems to be right and looking at some examples I got from internet...everybody seems to use that call same way...but not sure why it is nor working for me.
Can anyone see any problem or help me with this please?
Thanks