Hi,
I have created a synonym for one of the procedures PRC_CALCULATE present in a remote database RMT_DB.
I am connected to the remote database through a DB-LINK.
Since in the local DB a procedure with the same name is present I have created the synonym for the remote procedure with a different name. While compiling is form 12C, it is not giving me an error. But in the runtime, it is throwing me an error as shown below. I have already provided the grants for the db-link user in the remote database for that procedure.
If I try to access the remote procedure with the synonym_name itself, it is getting accessed, but for "public.synonym_name" (Where the "Public" is getting appended as a prefix to the procedure implicitly in the runtime) it is throwing an error.
Could anyone please help me with this?