Oracle SQL,PL/SQL

What is in and in out Procedure Parameter in Pl/Sql?

parameter
Avatar of shohal
Written by shohal

How to pass parameters to Procedures and Functions in PL/SQL?

In PL/SQL, we can pass parameters to procedures and functions in three ways.

1) IN type parameter: These types of parameters are used to send values to stored procedures.

What is in and in out Procedure Parameter in Pl/Sql? | TechTweet
What is in and in out Procedure Parameter in Pl/Sql? | TechTweet


2) OUT type parameter: These types of parameters are used to get values from stored procedures. This is similar to a return type in functions.
3) IN OUT parameter: These types of parameters are used to send values and get values from stored procedures.

What is in and in out Procedure Parameter in Pl/Sql? | TechTweet
What is in and in out Procedure Parameter in Pl/Sql? | TechTweet

About the author

Avatar of shohal

shohal

I have profession and personal attachment with custom ERP Software development, Business Analysis, Project Management and Implementation almost (36) ,also Oracle Apex is my all-time favorite platform to developed the software. Moreover i have some website development experience with WordPress. For hand on networking experience DevOps and CCNA, it create me a full package. Here are some core programming language with networking course i have been worked: Oracle SQL ,PL/SQL,Oracle 19c Database , Oracle Apex 20.1,WordPress,Asp.Net ,MS SQL ,CCNA ,Dev Ops, SAP SD

Leave a Comment