Oracle PL/SQL - Passing parameters to procedures

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

Introduction

PL/SQL allows you to pass parameters to procedures:

Demo

SQL>
SQL> Create or replace procedure p_helloTo (i_tx varchar2)
  2  is-- from   w ww . ja  va 2  s. c om
  3      my_val varchar2(256):='Hello, '||i_tx||'!';
  4  begin
  5      dbms_output.put_line(my_val);
  6  end;
  7  /

Procedure created.
SQL>
SQL> begin
  2    p_helloTo('Everybody');
  3  end;
  4  /
Hello, Everybody!

PL/SQL procedure successfully completed.
SQL>

Related Topic