Function Call « Stored Procedure Function « Oracle PL / SQL

  1. Oracle PL / SQL
  2. Stored Procedure Function
  3. Function Call




1.Call function and store the return value to a variable
2.Call function in dbms_output.put_line
3.Use a user-defined function in stored procedure
4.Local Subprograms
5.Calling a Function
6.This function cannot be called from a SQL statement: cannot perform a DML operation inside a query
7.This function can be called from a SQL statement.
8.Function with insert statement can be called from a DML statement.