Define in parameter : Parameter IN « Stored Procedure Function « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Stored Procedure Function
  3. Parameter IN

Define in parameter

  


SQL> -- define in parameter
SQL>
SQL> set serverout on;
SQL>
SQL> create or replace
  2  procedure out_parms( p_parm in number ) as
  3  begin
  4   null;
  5   dbms_output.put_line(p_parm);
  6  end out_parms;
  7  /

Procedure created.

SQL>
SQL> exec out_parms( 123 );
123

PL/SQL procedure successfully completed.

SQL>








Related examples in the same category

1.Use 'IN' parameters
2.Column type parameter
3.Demonstrate the behavior of IN, OUT, and IN OUT parameter modes.
4.This procedure will not compile, since it attempts to modify an IN parameter.