what is the difference between a procedure and a function in oracle?
1) Function Have to return a single value to the calling program whereas Procedures do not return any value except assigning values to OUT variables.
2) Functions can be called in sql statements whereas Procedures cannot.
3) Functions cannot return images whereas Procedures can return images.
thanks a lot for your answer..