OUT Parameters

Question

Can you rename the OUT parameter so that it isn't displayed with the @ sign before the parameter name for example here it displated @p_avg_salary?

Also can you use the out parameter in another query?

Answer 1

Hi Cyd-Marie!

Thanks for reaching out!

Please accept my apologies for the delayed response.

Actually this is a system variable and you cannot skip @ before the name of the variable.

Also, you cannot use OUT parameter from one stored procedure to another. They are defined in the scope of the stored procedure.

Hope this helps.
Best,
Martin

Submit an answer