Can sql stored procedures return character values? uzumymw_

​I have a sub procedure, which returns a message text(OUT parameter) based on a message id(IN parameter). I want to return a string of text upon returning and not using the OUT parameter. Just like we do in rpgle using return opcode.
Apparently stored procedures can only return integers?
I don’t want to use an out parameter and then using it where needed. The above procedure fetches multiple strings upto 50, so I will need 50 such variables in the calling pgm/procedure.
Can I just call that stored procedure directly where the return value is needed?
submitted by /u/uzumymw_[link][comments] Read More 

Verified by MonsterInsights