Home » SQL & PL/SQL » SQL & PL/SQL » use index by
icon5.gif  use index by [message #232527] Fri, 20 April 2007 21:23 Go to next message
Rafeek
Messages: 159
Registered: April 2007
Location: egypt
Senior Member
HI all

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
Re: use index by [message #232539 is a reply to message #232527] Sat, 21 April 2007 01:19 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The error comes from the type of your column.
As you don't tell us what it is we can't help you more.
Post a "desc" of your table and use code tags.

Regards
Michel
Previous Topic: Index on column with 90% rows Null
Next Topic: dbms_xmlgen
Goto Forum:
  


Current Time: Sat Dec 10 10:38:20 CST 2016

Total time taken to generate the page: 0.07477 seconds