We are having a similar problem with procedures. In oracle, we set the role for a user to have access to a specific schema (each project has it's own schema), however, when running a procedure in that schema it appears that it tries to find the procedure everywhere but where it exists.



The following is the list and order of statement sent trying to find the procedure.



1. user_procedure

SELECT arg.overload AS object_uniqueidentifier, arg.argument_name AS parameter_name, arg.data_type AS parameter_datatype,

arg.in_out AS parameter_mode, arg.data_precision AS parameter_precision, arg.data_scale AS parameter_scale,

arg.DEFAULT_VALUE AS parameter_defaultvalue, arg.char_length AS parameter_size, arg.POSITION AS position

FROM user_procedures procs LEFT JOIN user_arguments arg ON procs.object_id = arg.object_id AND arg.data_level = 0

WHERE procs.object_type = 'PROCEDURE' AND UPPER (procs.object_name) = UPPER ('P_INSERT_U_LOG_USAGE')

ORDER BY arg.POSITION



2. user_synonyms

SELECT table_owner, table_name

FROM user_synonyms

WHERE synonym_name = UPPER ('P_INSERT_U_LOG_USAGE')



3. all_synonyms

SELECT table_owner, table_name

FROM all_synonyms

WHERE synonym_name = UPPER ('P_INSERT_U_LOG_USAGE')



It never looks in all_procedures.

Hi Kevin, Please open a support ticket so we can investigate if this is a bug or a config issue: https://www.appeon.com/standardsupport/newbug