I have a database "A" which accesses a table "B_TBL" in database "B" via database link to retrieve and insert data data. I also have a function in database "A" which get a BLOB from a table in database "B" over a database link. Since, I cannot create a View which retrieves a BLOb over a database link I have created a function. I am using a GLOBAL TEMPORARY table to get the BLOB in this function. The GLOBAL_NAMES is set to TRUE therefore I cannot have the same database link name in TEST and PRODUCTION and therefore requires me to change the View the Functions when I publish this from one database to another. I understand the need for the GLOBAL_NAMES to be set to true but is there a way that I could not have to change the View or modifying the functions when I publish on diferent databases? 

------------------------------------------------------------------------------- 

DATABASE A:

GLOBAL_NAMES = TRUE

CREATE PUBLIC DATABASE LINK B_DATABASE.XYZ.WORLD
 CONNECT TO USERB
 IDENTIFIED BY password
 USING 'B_DATABASE.XYZ.WORLD';

CREATE VIEW B_TBL
AS
SELECT ID
FROM B_TBL@B_DATABASE.XYZ.WORLD;


CREATE GLOBAL TEMPORARY TABLE photo_temp
(
  ID         NUMBER,
  photo  BLOB
)
ON COMMIT DELETE ROWS
NOCACHE;



CREATE OR REPLACE function get_photo(id_p in number ) RETURN BLOB
is
photo_data blob := empty_blob();
begin


INSERT INTO photo_temp(ID,photo)
select ID,photo
from B_TBL@B_DATABASE.XYZ.WORLD
WHERE ID = id_p;


select photo_temp
into photo_data
from photo_temp
WHERE ID = id_p;

  return photo_data;  

exception
when NO_DATA_FOUND THEN
  ROLLBACK;
  RETURN NULL;
when others then
 rollback;
 RAISE_APPLICATION_ERROR('-20015','Exception in Function: get_photo(id_p in 
number ). id: ='||id_p||', SQLERRM = '||SQLERRM||', SQLCODE = '||SQLCODE);
end get_photo;
/
 

-------------------------------------------------------------
DATABASE B: 
TNS ENTRY: B_DATABASE.XYZ.WORLD
GLOBAL_NAMES = TRUE

CREATE TABLE B_TBL(
 ID NUMBER,
 PHOTO BLOB
);