use index by

• • Reply

  13 years ago

  by Rafeek

  Rafeek

  US, United States

  Joined 15 years ago
  i use
  type jobs_tabtype is table of jobs%rowtype
  index by jobs.job_id%type;
  
  
  and it work without error
  
  when i try to use
  type emp_tab_typ is table of EMPLOYEEs%rowtype
  index BY EMPLOYEES.EMPLOYEE_ID%type;
  emp_tab emp_tab_typ;
  
  i get error
  PLS-00315: Implementation restriction: unsupported table index type
  
  why i get error in the secod code and how can i solve it?
  
  thax
  Rafeek
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  Report abuse