EXEC SP ‘procAlertGetOut’ WITH 2 params return

If you have questions or if you want to share your opinion about Aware IM post your message on this forum
Post Reply
swiftinitpvtltd
Posts: 370
Joined: Sat Apr 28, 2018 3:33 am
Location: India
Contact:

EXEC SP ‘procAlertGetOut’ WITH 2 params return

Post by swiftinitpvtltd »

EXEC SP ‘procAlertGetOut’ WITH
‘@alerID’=SPParam.AlertId,’@alertName’=SPParam.AlertName OUT

What if I have to return 2 params from stored proc. How do I write that?
BLOMASKY
Posts: 1470
Joined: Wed Sep 30, 2015 10:08 pm
Location: Ocala FL

Re: EXEC SP ‘procAlertGetOut’ WITH 2 params return

Post by BLOMASKY »

I believe you can have many input and output params. Just put an out after each one. Did you try that?

The only limitation is with the EXEC_SPF. It can only have 1 OUT


Bruce
swiftinitpvtltd
Posts: 370
Joined: Sat Apr 28, 2018 3:33 am
Location: India
Contact:

Re: EXEC SP ‘procAlertGetOut’ WITH 2 params return

Post by swiftinitpvtltd »

That worked! Thank you.
Post Reply