Question is previously when we use two prameters then only IN parameters where shown but in this 3 parameters where shown including OUT ONE Fig 1 Table created same as done in assignment (basically code part) Fig 2 expecting 2 Input box instead of three (although it works fine even when I add data to two only but why 3) (checked multiple times the code still can't figure out what's wrong why three input needed even mentioned clearly on input page Two are IN type and One is OUT type ) (Query didn't run when I run "set @v_emp_no = 0 ; call emp_info("Aruna","Journel"); select @v_emp_no; ")

Hi Mayank! Thanks for reaching out. If you run the procedure from the lightning bolt from the Schemas and you have three parameters to input, this is because they are written with capital letters - IN and OUT. If you type them with small letters, the output parameter will not be shown. This is a well-known bug in the Workbench. If you run it with a query you need the following code: set @p_emp_no = 0; call emp_info('Aruna', 'Journel', @p_emp_no); select @p_emp_no; Hope this helps. Best, Tsvetelin

Follow this topic

Mayank Mittal

Last answered:

05 Dec 2022

Posted on:

03 Dec 2022

Resolved: Facing some weird issue while creating Procedures

in SQL / Variables

1 answers ( 1 marked as helpful)

Tsvetelin Tsonkov

Instructor

Posted on:

05 Dec 2022

Helpful answer

Resolved: Facing some weird issue while creating Procedures

Submit an answer

related questions