Working with TABLE Type

CREATE OR REPLACE TYPE SCOTT.v_emp_data AS OBJECT

(

  EMPNO    number(4),

  ENAME     varchar2(10),

  JOB  varchar2(9),

  mgr number(4),

  hiredate date,

  sal  number(7,2),

  comm   number(7,2),

  deptno     number(2)

)

/

CREATE OR REPLACE TYPE SCOTT.v_emp_tab as table of  v_emp_data;

/

CREATE OR REPLACE PROCEDURE scott.d_loaddata (i_data v_emp_tab)

AS

   v_data   v_emp_tab;

BEGIN

   INSERT INTO emp_load

      SELECT *

        FROM TABLE (i_data);

   NULL;

END;