74: -- Findwarehouse database name
75: -- ----------------------------
76: select name
77: into l_db_name1
78: from v$database;
79:
80:
81: -- --------------------------------------------------------
82: -- Loop the complete set of instances
128: -- ----------------------------
129: -- Check if same instance
130: -- ----------------------------
131: IF g_rec(i).valid
132: THEN l_stmt := 'SELECT name '||'FROM v$database@'||g_rec(i).db_link;
133:
134: EDW_LOG.Debug_Line('');
135: EDW_LOG.Debug_Line(l_stmt);
136: EXECUTE IMMEDIATE l_stmt INTO l_db_name2;