create or replace function f(a varchar2) return varchar2
is
begin
return a;
end;
Function created.
create table b (c varchar2(2 char))
Table created.
create index b_i on b (f(c)) online
ORA-30553: The function is not deterministicMore Details: https://docs.oracle.com/error-help/db/ora-30553
create index b_i2 on b (substr(f(c),1,3)) online
ORA-30553: The function is not deterministicMore Details: https://docs.oracle.com/error-help/db/ora-30553
create or replace function f(a varchar2) return varchar2 deterministic
is
begin
return a;
end;
Function created.
create table b (c varchar2(2 char))
ORA-00955: name is already used by an existing objectMore Details: https://docs.oracle.com/error-help/db/ora-00955
create index b_i on b (f(c)) online
ORA-01450: maximum key length (6398) exceededMore Details: https://docs.oracle.com/error-help/db/ora-01450
create index b_i2 on b (substr(f(c),1,3)) online
Index created.