In this example, you used that variable in the output parameter and before that it was initialized to zero. But I do not understand the data type of the variable before it was used to store the output of the stored procedure.

Hi Abdul! Thanks for reaching out. The important thing is that the output parameter is INT, so you need to provide such data type. This is why we initialize the variable with 0, which is INT and provide it as an output parameter to the procedure. Hope this helps. Best, Tsvetelin

Follow this topic

Abdul Hakeem

Last answered:

02 Dec 2022

Posted on:

28 Nov 2022

Why is the data type of the variable not specified?

in SQL / Variables

1 answers ( 0 marked as helpful)

Tsvetelin Tsonkov

Instructor

Posted on:

02 Dec 2022

Why is the data type of the variable not specified?

Submit an answer

related questions