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
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
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?

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: 65090
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.

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

Current Time: Fri Jul 28 10:02:25 CDT 2017

Total time taken to generate the page: 0.09256 seconds