Question: what is the difference between input and output parameters in stored procedure?
Answer: A stored procedures and functions may have input, output, and input/output parameters. Input parameter is a parameter whose value is passed into a stored procedure/function module. ... Output parameter is a parameter whose value is passed out of the stored procedure/function module, back to the calling PL/SQL block.