Parameter Modes Supported by PL/SQL in Oracle

Q

What Are the Parameter Modes Supported by PL/SQL in Oracle?

✍: FYIcenter.com

A

PL/SQL supports 3 parameter modes on procedure/function parameters:

  • IN: This is the default mode. IN parameters allow the calling code to pass values into the procedure or function.
  • OUT: OUT parameters allow the procedure or function to pass values back to the calling code.
  • IN OUT: IN OUT parameters allow the calling code to pass values into and receive values from procedure or function.

 

⇒Creating Oracle PL/SQL Procedures and Functions

⇒⇒Oracle Database Tutorials

2018-10-19, 484👍, 0💬

General MySQL Oracle SQL Server