How to call on a object member procedure a nested table attribute?
Have this objects and table types: 

    CREATE TYPE Person_typ AS OBJECT
    ( 
        name CHAR(20),
        ssn CHAR(12),
        address VARCHAR2(100)
    );

    CREATE TYPE Person_nt IS TABLE OF Person_typ;
    
    CREATE TYPE dept_typ AS OBJECT
    ( 
        mgr Person_typ,
        emps Person_nt,
        MEMBER PROCEDURE getEmp(name IN  CHAR(20)),
    );

    CREATE TABLE dept OF dept_typ;

How i can get the employer with the function getEmp and argument name ? 
 
    CREATE TYPE BODY dept_typ AS 
       MEMBER  PROCEDURE getEmp(name IN CHAR(20)),
       BEGIN
          ????? What i put where ????
       END;
    END;


My problem is that i can't make **self.emps** like I can do with self.mgr ... and i don't know why....

Thanks,
Joao
How to call on a object member procedure a nested table attribute?
===

Have this objects and table types: 

    CREATE TYPE Person_typ AS OBJECT
    ( 
        name CHAR(20),
        ssn CHAR(12),
        address VARCHAR2(100)
    );

    CREATE TYPE Person_nt IS TABLE OF Person_typ;
    
    CREATE TYPE dept_typ AS OBJECT
    ( 
        mgr Person_typ,
        emps Person_nt,
        MEMBER PROCEDURE getEmp(name IN  CHAR(20)),
    );

    CREATE TABLE dept OF dept_typ;

How i can get the employer with the function getEmp and argument name ? 
 
    CREATE TYPE BODY dept_typ AS 
       MEMBER  PROCEDURE getEmp(name IN CHAR(20)),
       BEGIN
          ????? What i put where ????
       END;
    END;


My problem is that i can't make **self.emps** like I can do with self.mgr ... and i don't know why....

Thanks,
Joao