How to Call a Function from PL/SQL With or Without Parameters : Function « Function Procedure Packages « Oracle PL/SQL Tutorial






If there are no parameters to pass, you can simply call the function without the parentheses.

To pass actual values, you can use commas as placeholders for parameters.

SQL>
SQL> CREATE OR REPLACE FUNCTION squareme(thenum number)
  2       RETURN NUMBER IS
  3  BEGIN
  4       RETURN thenum * thenum;
  5  END squareme;
  6  /

Function created.

SQL>
SQL> BEGIN
  2       DBMS_OUTPUT.PUT_LINE('9 squared is ' || squareme(9) );
  3  END;
  4  /
9 squared is 81

PL/SQL procedure successfully completed.

SQL>








27.1.Function
27.1.1.Functions
27.1.2.Describe a user-defined function
27.1.3.create or replace FUNCTION iifn(boolean_expression in BOOLEAN,true_number IN NUMBER,false_number IN NUMBER)
27.1.4.Storing PL/SQL function in the Database
27.1.5.Create a simple function
27.1.6.Creating a Function to deal with business rules
27.1.7.CREATE OR REPLACE a function
27.1.8.Calling a Function
27.1.9.Calling a Function for a table
27.1.10.Function without parameters
27.1.11.Exit a function
27.1.12.How to Call a Function from PL/SQL With or Without Parameters
27.1.13.Local Subprograms
27.1.14.Dependency Example
27.1.15.The FullName Function
27.1.16.PLW-05005: function NO_RETURN returns without value at line 21
27.1.17.Use function to check passwords