Resolved: Output parameters
Hi,
What's the purpose of saving output parameters in the database. In which case it will be useful? Kindly explain.
Thanks in advance.
2 answers ( 2 marked as helpful)
Hi Anitha!
Thanks for reaching out.
The output parameters in stored procedures are used to return some value or values. A stored procedure can have any number of output parameters. The simple logic is this — if you want to return 1 value then use 1 output parameter, for returning 5 values use 5 output parameters and so on.
Hope this helps.
Best,
Tsvetelin
Thank you so much for the clarification.