DB Synonym not working with APEX Listener 2.0
Hi,
We are using "Configuring Multiple Database - Routing Based on the Request Path Prefix" in APEX Listener 2.0.
Our configuration:
Rule Type: Request Path
Routing Rule: /avon
DB Connection: avon/password
Goal:
http://our-host/apex/avon/foo can work.
The foo function is owned by another schema, avon1. But in avon schema, we have created a synonym called foo pointing to avon1.foo.
"http://our-host/apex/avon/foo" does not work. However, if I prefix the function name with schema name (i.e., change the URL to "http://our-host/apex/avon/avon1.foo"), it will work.
Question:
Is there any way to get around this? We don't want to prefix the function name with schema owner name.
Regards,
Avon