Problem with a storeProcedure

eric.avila · July 21, 2021, 2:50pm

Hi,

I exec a storeprocedure and try to get the value of the store but i can`t.

but i only get None with the funtion “call.getResultSet()”

so i think the problem is the SP, i tried with return, with select also output int the store.

In all the situations if i exec the SP directly in SQL always give me a value,

what i made wrong?

pturmel · July 21, 2021, 4:52pm

Please share your stored procedure and the scripts you tried. We aren’t mind readers. /:

nminchin · July 23, 2021, 4:18am

I think it’s in line 15 of the SP, that’s my hunch. That feels wrong to me

pturmel · July 23, 2021, 12:33pm

Except for Nick.

Eric, did you find a problem on line 15?

victordcq · July 23, 2021, 12:34pm

imagine if Nick was right xd

eric.avila · July 23, 2021, 2:26pm

Sorry guys, but i really need to give to solution to the problem, so i made a select after exec the SP, but the SP its something like:

and tried to get the result with :

results = call.getResultSet()
table = event.source.parent.getComponent(table)
table.data = results

pturmel · July 23, 2021, 3:17pm

The final line in your SP is syntactically incorrect. Try:

Select @resultado AS out