976798 wrote:That's exactly the difference. A function always returns a value, whereas a procedure does not.
except return value differentiation.
why we can not call a procedure in a select statement like a pl/sql function.A function returns a value whereas the procedure doesn't. A procedure could have an out parameter, however how would you implement that in a SQL query? how would you define the out parameter variable within SQL, what would it be and where/how to define it?