[Home] [Help]
1601: IS
1602: CURSOR c_global_names_opt
1603: IS
1604: SELECT param.VALUE
1605: FROM v$parameter param
1606: WHERE param.NAME = 'global_names';
1607:
1608: CURSOR c_global_names_val
1609: IS
1609: IS
1610: SELECT GLOBAL_NAME val
1611: FROM GLOBAL_NAME;
1612:
1613: l_gname_set v$parameter.VALUE%TYPE;
1614: l_gname_val GLOBAL_NAME.GLOBAL_NAME%TYPE;
1615: l_source_link VARCHAR2 (128);
1616: l_target_link VARCHAR2 (128);
1617: BEGIN