HI,
I am facing the below issue while executing the SP.
I dont see any issue with other SP on this DB.
I am running the follwing command
exec emp_getDetails
Where emp_getDetails is name of SP.
The synonym "emp_getDetails" referenced synonym "emp_getDetails". Synonym chaining is not allowed.
Can you please let me know what could be the reason for this issue and how it can be amend?