use index by

oracle United States
  • 13 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
    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?


Post a reply

No one has replied yet! Why not be the first?

Sign in or Join us (it's free).


Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“Measuring programming progress by lines of code is like measuring aircraft building progress by weight.” - Bill Gates