Oracle PL/SQL - PL SQL Function Procedure Package Parameter

  1. HOME
  2. Oracle PL/SQL
  3. PL SQL Function Procedure Package
  4. Parameter

Introduction

The procedure declaration starts with the keyword IS and is preceded by a specification.

The specification consists of two parts:

  • Header: You need to name a procedure according to the standard rules for PL/SQL identifiers.
  • Optional Parameter List: The list is enclosed in parentheses. Parameters are separated by commas and each has the form: 
variable1 [type] datatype [DEFAULT value]

Parameter names will be used inside the procedure. For example, you can prefix them.

Procedures may have three types of parameters:

  • IN the default type; an input value will be passed by the calling routine,
  • OUT,
  • IN OUT.

Procedures may have up to 256 parameters.

The datatypes of these parameters are more generic than the datatypes of regular variables.

Parameters can have default values.

Related Topics