Can someone tell me if it is possible to get a result set from this function if the stored procedure uses a temp table? I have been trying and my result set row count is zero.
Thank you
Before you edited your post this last time I saw that you had this line in your script:
spCall.registerInParam(“procedure”, system.db.VARCHAR, 40)
It should be
spCall.registerInParam(“procedure”, system.db.VARCHAR, "40")
You might try fixing that line and the other line that was similar but with a 20 instead of 40 and see if that doesn’t fix the problem.
When pasting code or other plain text in the forum, use a line with just three backquotes above the code, and again below the code, so it formats nicely.