Forum Stats

  • 3,872,035 Users
  • 2,266,368 Discussions


registering functions from 1 db to another db using a link

clifford_d Member Posts: 94
edited Sep 30, 2019 10:53AM in Discoverer

Created a pl/sql function in database A and have registered it in admin layer.  Now we need to register the same function in database B.

The function has been shared to database B via a db link, but can't seem to see it in database B to register it.

Any suggestions ?  


  • mrigg
    mrigg Member Posts: 98 Blue Ribbon
    edited Sep 25, 2019 12:25PM

    I haven't actually done that, but in the Register Functions dialog in Discoverer Admin, there's a drop down for "Database Link".  Can you change that to "database A" instead of "Default Database"?  Then when you select import, does the function show up in the list?

  • clifford_d
    clifford_d Member Posts: 94
    edited Sep 25, 2019 1:22PM

    tried that.  Did not work.

  • sbeck-Oracle
    sbeck-Oracle Member Posts: 116 Employee
    edited Sep 30, 2019 10:53AM

    You mention you are unable to see the function in Database B.  Do you mean from other than Discoverer Administration (Admin), using another tool?

    I am not clear on exactly what you are attempting to do.  I can say that you cannot have two Functions registered by the same name.


    Premier support for Discoverer 11g ended June 2014.  Version is the final / terminal release of the Discoverer product.  Discoverer is under sustaining support, which limits our ability to assist you.  Please review the alert section at the bottom of this update.

    Discoverer is at end of life.  Any software update (OS, browser, Java, WLS, EBS, etc.) released after June 2014 has not specifically been certified or tested and may cause issues for Discoverer.  Therefore, it is important to maintain a stable Discoverer environment for as long as it takes to move to OBIEE or other replacement.