In PL/SQL, procedures support all the parameter modes listed below, whereas, functions only support the IN parameter mode. Here are all the parameter modes in PL/SQL for procedures and functions:

  • IN: This is the default mode, which allows the calling code to pass values in the procedures or functions.
  • OUT: The OUT parameters allow the procedures or functions to pass the values back towards the calling code.
  • IN OUT: The IN OUT parameters allow the calling code to pass the values in and also to receive values from procedures or functions.
BY Best Interview Question ON 27 Jun 2020