Hi,
can someone clarify what privilege is needed to successfully run sdo_cs.create_pref_concatenated_op on Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.21.0.0.0?
I can successfully run other functions in the package, which indicates that I am not lacking the execute privilege on the package, but when I try to run the following sample code, it throws the error.
begin
sdo_cs.create_pref_concatenated_op(
1111112,
'TEST_CONCATENATED_OPERATION',
TFM_PLAN(
SDO_TFM_CHAIN(
41155,
14205, 4267,
1241, 4269)
),
null);
end;
/
Error report -
ORA-01031: insufficient privileges
ORA-06512: at "MDSYS.SDO_CS", line 2175
ORA-06512: at "MDSYS.SDO_CS", line 2111
ORA-06512: at line 2
01031. 00000 - “insufficient privileges”
Thank you
Flavio