CreateSProcCall call not working

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.