What Are the Parameter Modes Supported by PL/SQL

Q

What Are the Parameter Modes Supported by PL/SQL? - Oracle DBA FAQ - Creating Your Own PL/SQL Procedures and Functions

✍: 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.

2007-04-25, 6015👍, 0💬