HERE MY OUTPUT IS ALSO ASKING FOR THE INPUT WHY?

Hi everyone! Thanks for reaching out. @: Shabnam and Yogesh Thanks for sharing this piece of information with the Community! @: Tanmay Your code in the WHERE clause is not correct. Please, correct it. You typed EMP EMP_NO instead of EMP_NO. Also, good practice is to type with capital letters only the keywords. Sometimes, the Workbench behaves like this when the IN and OUT keywords are written with capital letters. If you write them using small letters the problem will disappear. Hope this helps. Best, Tsvetelin

I had the same situation. Writing 'out' instead of 'OUT' solved the issue but dunno why.

code is not correct in WHERE clause and changing OUT to out change the how input works idk how.

Follow this topic

Tanmay Chakraborty

Last answered:

15 Dec 2021

Posted on:

02 Nov 2021

I HAD GIVEN OUTPUT AS SALARY_P BUT WHEN I CALLED THE PROCEDURE IT ALSO ASKING FOR IN OF THE OUT

in SQL / Stored Procedures with an Output Parameter

3 answers ( 0 marked as helpful)

Shabnam Abdullayeva

Posted on:

02 Nov 2021

Yogesh Batra

Posted on:

07 Nov 2021

Tsvetelin Tsonkov

Instructor

Posted on:

15 Dec 2021

I HAD GIVEN OUTPUT AS SALARY_P BUT WHEN I CALLED THE PROCEDURE IT ALSO ASKING FOR IN OF THE OUT

Submit an answer

related questions