Question: what is difference between stored procedure and function in oracle?
Answer: The function must return a value but in Stored Procedure it is optional. ... Functions can have only input parameters for it whereas Procedures can have input or output parameters. Functions can be called from Procedure whereas Procedures cannot be called from a Function.