Last answered:

22 May 2024

Posted on:

18 Feb 2023


OUT Parameters

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?

1 answers ( 0 marked as helpful)
Posted on:

22 May 2024


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.

Submit an answer