Last answered:

07 Oct 2022

Posted on:

05 Oct 2022

1

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)
Instructor
Posted on:

05 Oct 2022

0

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

Posted on:

07 Oct 2022

0

Thank you so much for the clarification.

Submit an answer