Passing %TYPE and %ROWTYPE as Parameters

  

SQL>
SQL> create table myTable (
  2    col varchar2(10)
  3  );

Table created.

SQL>
SQL>
SQL> create or replace procedure ADD_ROW(p_col myTable.COL%TYPE) is
  2  begin
  3    insert into myTable values (p_col);
  4  end;
  5  /

Procedure created.

SQL>
SQL>
SQL> drop table myTable;

Table dropped.

SQL>
SQL>

Related examples in the same category

1.	Declare scalars based on the datatype of a previously declared variable
2.	rowtype and type
3.	Select only one row for column type variable
4.	Creating a procedure and call it
5.	Column%type parameter
6.	reference table data with tableName.columnName%type
7.	Add row to table with tableName.columnName%type

Passing %TYPE and %ROWTYPE as Parameters : Type « PL SQL « Oracle PL / SQL

Related examples in the same category