.NET C C++ CSS DBA General HTML Java JavaScript JSP JUnit MySQL Networking Oracle Perl Perl PHP PL/SQL RSS Software QA SQL Server Struts Unix Windows XHTML XML

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, 6135👍, 0💬

.NET C C++ CSS DBA General HTML Java JavaScript JSP JUnit MySQL Networking Oracle Perl Perl PHP PL/SQL RSS Software QA SQL Server Struts Unix Windows XHTML XML