registering functions from 1 db to another db using a link

clifford_d

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

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

tried that.  Did not work.

sbeck-Oracle

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.

Regards,
Sharon

Premier support for Discoverer 11g ended June 2014.  Version 11.1.1.7.0 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.