0 Replies Latest reply on Jun 5, 2013 7:43 PM by Avhsu-Oracle

    DB Synonym not working with APEX Listener 2.0

    Avhsu-Oracle
      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