This discussion is archived
7 Replies Latest reply: Feb 19, 2013 10:17 PM by 979801 RSS

What is Difference  between Procedure and function in pl/sql

979801 Newbie
Currently Being Moderated
Hello,
A question which comes to me again and again that is,What is difference between procedure and function in pl/sql except return value differentiation.why we can not call a procedure in a select statement like a pl/sql function.when there is a procedure then why we need to have a function in pl/sql.
Please give me solution.
Thank You
regards
aaditya.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points