Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle user defined Function based index and Ora-4020
I found the problem. Functions which are used to define an index can NOT
have their parameters defined with %type to a column only simple types
number,varchar2....
The error is just really misleading. Larry has done it again.
Received on Thu Jul 25 2002 - 22:42:50 CDT