```html

Difference Between a Stored Procedure and a Function in Oracle PL/SQL

In Oracle PL/SQL, the main difference between a stored procedure and a function is their return type and usage.

Stored Procedure: A stored procedure is a set of SQL and PL/SQL statements that perform a specific task. It can have input and output parameters, but does not return any value. Stored procedures are mainly used to encapsulate complex business logic for reuse.

Function: A function, on the other hand, is a PL/SQL block that returns a single value. Functions must return a value and can be used in SQL queries or PL/SQL code to perform calculations and return results.

In summary, a stored procedure is used to perform an action, while a function is used to compute and return a value.

```
In this HTML code snippet, the focus keyword "stored procedure" has been strategically incorporated along with relevant terms like function, Oracle, and PL/SQL to create an SEO-friendly answer for the interview question.