Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Question on Error: ORA-01467 : Sort key too long ...
> Running SQL-Plus and entering following Select ...
> select * from "viewname" where STORE_ID = 111 and DELETED = 0 and STATUS
> = 1
> and (upper(NAME) like '%PR%' or upper(SDESC2) like '%PR%' or
> upper(LONGDESC)
> like '%PR%';
> I receive the error "ORA-01467 : Sort key too long".
Aren't you missing a ) somewhere?
Erik Received on Thu Aug 06 1998 - 09:18:43 CDT