Re: Cannot create an index based on a function

 Hi, did you try virtual column? Does Hybris 'crash' with it as well? Le ven. 24 juin 2016 à 07:41, Thomas Kellerer <thomas.kellerer_at_mgm-tp.com> a écrit :

> Mark W. Farnham schrieb am 22.06.2016 um 18:05:
> > Perhaps:
> >
> > create unique index tk_test on
> > orders(code,cast(coalesce_wrapper1(p_versionid) as varchar2(255 byte)));
> >
> > will work. I think casting the return to your desired maximum length
> *might*
> > be the most performant.
> >
> > Unfortunately I don't have a database handy with extended varchar2, so I
> > cannot test that for you.
>
>
> Thanks, but unfortunately that syntax also makes Hybris crash (and so does
> the substr() version).
>
>
> Thomas
>
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l