Re: Cannot create an index based on a function

  • From: Franck Pachot <franck@xxxxxxxxxx>
  • To: thomas.kellerer@xxxxxxxxxx, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 24 Jun 2016 16:30:04 +0000

 Hi, did you try virtual column? Does Hybris 'crash' with it as well?
Le ven. 24 juin 2016 à 07:41, Thomas Kellerer <thomas.kellerer@xxxxxxxxxx>
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



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



Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 06-2016