How to activate the auto-index feature in Oracle 19c Enterprise Edition? To activate on PDB send me the error: BEGIN dbms_auto_index.configure('AUTO_INDEX_MODE','IMPLEMENT'); END; Informe de error - ORA-40216: función no soportada ORA-06512: en "SYS.DBMS_SYS_ERROR", línea 79 ORA-...

Hi Tom, First of all, I want to thank you for all the things which you have done and doing for Oracle community. It inspire me to learn more and more. Now my question is -- Is there any way by which we can hide the procedures and functions code so the user can only execute it but...

Hi, I have created an application that is tracking a set of processes that are being run from a master table. When a process is completed, a flag in a column name PROC_EXEC_STATUS changes from N to Y for each process. I want my oracle apex application to refresh when the flag for...

I have PL/SQL package with a function that returns a list of item numbers. This package/function is repeatedly called by online with multiple users; passing parameters to the function to use within the SQL statement(s). A new string (short list of item types) will now be passed t...

<u></u><u>We are building a system where:</u> - Application users connect using different DB users - They call DBMS_SCHEDULER.CREATE_JOB to create jobs - Jobs are always expected to execute in the application user(APPUSER) schema - We call external C++ functions via LIBRARY objec...