Inside the function I have this assignments:
Code: Select all
Errcode1 = SQLBindCol(hStmt, 1, SQL.B.DEFAULT, res1)
** ... (more code)
@USER0 = res1;
** ... (more code)
I checked the log and @USER is receiving the correct value in the function. But, in the job if I try to use the job parameter its value is "#@USER0#" as a string.
I am embarrassed here in the office because I announced yesterday that I have the function(ality) ready.
I swear I tested it and it worked ok.
I am probably being victim of a global conspiracy.