There is a procedure that synchronizes the index in the database:

PROCEDURE UpdateIndex IS BEGIN dbms_application_info.set_module('MyModule', 'Run'); dbms_application_info.set_client_info('Sync Index'); CTX_DDL.SYNC_INDEX('OBJECT_IDX'); dbms_application_info.set_module('MyModule', 'Finished'); dbms_application_info.set_client_info('Sync Index'); END;

If you start the procedure manually, with the IDE, everything works correctly, but if the procedure starts from the backend, then in the v$session table the module and action fields are empty for some reason.

What could be the problem?

    1 answer 1

    Perhaps the session where UpdateIndex was called ended. Try

     select module, action from v$sqlarea where module='MyModule':

    or call in the same session

     dbms_application_info.read_module(module, action);